MrExcel Publishing
Your One Stop for Excel Tips & Solutions

vlookup a list box

Posted by Nancy on September 12, 2001 7:25 AM

Help, I've got a list box (sheet 1) that picks an item from sheet two. I want to link additional info from sheet 2 to sheet 1 (different cell).

=VLOOKUP("Drop Down 29",'Job Code Table'!A2:B1021,2,FALSE)

This returns a #N/A.

Thank you in advance!

Posted by Russell Hauf on September 12, 2001 8:11 AM

You cannot do a vlookup to a listbox. Just set your vlookup to look where the listbox is looking...make sense?

Hope this helps,