vlookup probs

[jim]

hello
I want to put in a vlookup formula so that i can change a referance number
in a cell and it will give me the relavent information ie 3000 will refer to
bill 3002 will be harry etc.
The formula i have put in is :- =VLOOKUP(D3,data,3)
where d3 is the cell with the numbers i want to change to get different
information. So ideally it will look for the value i type in d3 in the
range i have called data and give me the value in column 3 on the same row
within the data field.
I hope i have explained clearly.
thanks
jim

 

[jim]

I should add that data is on sheet 1 of the workbook, i think this is where
the problem lies
jim

 

[Frank Kabel]

Hi Jim
I think you already have everything. I would just add FALSE as 4th
parameter to search for an exact match. So use
=VLOOKUP(D3,data,3,FALSE)
where data is your range

Frank

 

[jim]

thanks all sorted
jim

Hi Jim
I think you already have everything. I would just add FALSE as 4th
parameter to search for an exact match. So use
=VLOOKUP(D3,data,3,FALSE)
where data is your range

Frank