Assigning a value from the option selected from the Drop Box.

[hubcitytiger]

I have a spread sheet where i have created a drop box in Cell i4. There are 56 choices in the drop box. These choices come from cells B160:B215. There are dollar values in cells C160:C215 correspond with B160:B215. I am trying to find a formula for G16 that will look at i4 and find the corresponding dollar value from C160:C215.

Help

James

[amulee]

You can try following formula for G16

=VLOOKUP(I4,$B$160:$C$215,2,0)

[rylo]

Hi

VLOOKUP should do it

Please Login or Register  to view this content.

rylo

[hubcitytiger]

Thanks for all of your help.. I GOT IT!!!!!!!!