simple vlookup
 

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

simple vlookup
 

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

simple vlookup
 

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

simple vlookup
 

Thanks a million dude!

"Pete_UK" wrote:

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

simple vlookup
 

Hi bj,

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

tx

"bj" wrote:

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

simple vlookup
 

You're welcome - thanks for feeding back.

Pete

On Apr 20, 10:44 am, vertigo
wrote:
Thanks a million dude!



"Pete_UK" wrote:
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- Hide quoted text -

- Show quoted text -