To Kevin Stecyk or Gord

[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

 

[Felipe]

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

 

[Kevin Stecyk]

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

 

[Ken Wright]

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.

 

[Gord Dibben]

Thanks Ken

Couldn't have stated the case any better.

Gord

 

[Ken Wright]