To Kevin Stecyk or Gord

  • Thread starter Thread starter Brian
  • Start date Start date
B

Brian

Thank You

Both worked perfect. But just so I can learn, what does
the number 2 in the vlookup function you both gave me
mean.
=VLOOKUP(C1,$A$1:$B$20,2,false)
=Vlookup(A1, J1:K50, 2, false)

and why did one formula have $ signs within the cell
location and not in the other

sorry for the questions, but you help is very appreciated

thanks,
Brian
 
Brian,

2 is the number of the column in the lookup matrix from
wich you want the data to be returned.

Check excel help on vlookup for more details

Regards,
Felipe
 
Hi Brian,

Glad it worked.

The number 2 is simply the second column for reference.

For example, if you had a larger table, say....

Starting col J

ID, Name, Age, Sex, Seniority, Position

You might have a vlookup with

=Vlookup(A1, J1:O50, 4, false)

Then, knowing the ID, you can get the sex of the individual.

It is simply a reference to which column.

Glad this worked for you.

Just one minor housekeeping item, it is best to leave the "subject" field
unchanged so that the thread remains unbroken. That way others can readily
follow along. But we do appreciate you coming back and letting us know it
worked.

Regards,
Kevin
 
The $ signs 'lock down' a reference so that it will not change if you copy and
paste the formula elsewhere. If it was a one-off formula then it would not need
the $ signs, but if you were going to copy the formula down a number of rows ,
then you would want the C1 part to change, eg so that it referenced C2, C3, C4,
C5 etc, but you would not want the reference to the table to change, and without
the signs it would.
 
Back
Top