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,
Russell
