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

On Apr 19, 3:06 pm, vertigo wrote:
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