simple vlookup

V

vertigo

Hi,

On the same spreadsheet, I have two segments of data: the first segment
(A1:H19) uses the data from the second segment (B22:H90) for calculations.

B2 will select a value from the drop down list it contains (based on B22:B90).
When B2 is selected, I want the value in C2 to change, according to the
corresponding value in C22:C90.

I cannot for the life of me get it right with vlookup. Can anybody please
help.

Much obliged
 
P

Pete_UK

It should be something like:

=VLOOKUP(B2,B$22:C$90,2,0)

B2 already exists in B22:B90 through your validation, and you want to
bring back data from the second column of your table (i.e. column C)
where there is an exact match (set by the 0 at the end of the
formula).

Hope this helps.

Pete
 
B

bj

What is the vlookup equation you are using?
I think is should be something like
in C2
=vlookup(b2,B22:H90,2,0)
 
V

vertigo

Thanks a million dude!

Pete_UK said:
It should be something like:

=VLOOKUP(B2,B$22:C$90,2,0)

B2 already exists in B22:B90 through your validation, and you want to
bring back data from the second column of your table (i.e. column C)
where there is an exact match (set by the 0 at the end of the
formula).

Hope this helps.

Pete
Click to expand...
 
Top