Using List/Combo Box with vLookup?

[aldino]

Ok what i need is a List/Combo box (not sure which one to use) that has the values 1-20, and when a certain value is selected, another cell shows the answer from a vlookup code, eg it searches for the number that is selected from the Box, and returns the value from another cell a few columns a long vertically.

EG.

If i select 20 from the box, another cell should have =VLOOKUP(20,B2:G43,6,TRUE)
if i select 10 it should be =VLOOKUP(10,B2:G43,6,TRUE)

Basically how can i link the value selected from the box, to do a certain code in another cell??

Thanks

 

[acw]

Hi

You can have the output from the combobox placed in a cell (say A1) then you use that cell in the VLOOKUP formula

=VLOOKUP(A1,B2:G43,6,TRUE)

HTH

Tony

 

[aldino]

ahh yes i see what you mean, thanks