simple vlookup

[Guest]

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

 

[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

 

[Guest]

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

 

[Guest]

Thanks a million dude!

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

 

[Guest]

Hi bj,

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

tx

 

[Pete_UK]

You're welcome - thanks for feeding back.

Pete

Thanks a million dude!






- Show quoted text -