Populate 2nd field from Combo Box

Topic

New Reply

Evening all

A schoolboy question, I must be braindead tonight

Control Toolbox Combo linked to G10 displaying a list from D35:D237 I want to display information in a seperate cell from E35:E237

Formula = =VLOOKUP($D$35:$E$237,G10,2,FALSE)

Answers by carrier pigeon please

Reply | Quote

Replies

You have the first two arguments reversed

=VLOOKUP(G10,$D$35:$E$237,2,FALSE)

Reply | Quote

Thanks MBarron

Although I have changed the fields a little and by applying your example I still get #N/A

=VLOOKUP(G10,$B$102:$C$186,2,FALSE

Any other thoughts?

TIA

Reply | Quote

Have you linked the combo box to the G10 cell? Enter the formula = G10 in a cell. If your result is not the same as what the combo box is displaying, then you can tell the combo box and the cell are not linked.

Reply | Quote