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 (A1,K1:L4,2, FALSE) and =VLOOKUP (A1,$K$1:$L$4,2, 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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!