Question: What is the difference between the following sets of code? = VLOOKUP ( A 1 , K 1 :L 4 , 2 , FALSE )
What is the difference between the following sets of code?VLOOKUP AK:L FALSE and VLOOKUP A$K$:$L$ FALSE The first is an approximate match and the second is an exact match. They will always return the same results. The first uses a relative cell reference and the second uses an absolute reference. The first uses an absolute cell reference and the second uses a relative reference.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
