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

"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