Listing a number when picking a name - VLOOKUP not working

[makkystyle]

Hey guys,

I have a spreadsheet where I am trying to reference a lookup table in another sheet from a drop-down menu in my main page. For some reason the VLOOKUP function I am using is not working. I have tried many things:

• Using [@ColumnName] or cell reference
• Using Names or specific cell ranges
• Using "--" to try and reduce problems with text matching
• Using simple numbers as references to troubleshoot

I really can't understand why this isn't working, can someone help?

Thank you!

[MarvinP]

Hi Markkystyle,

Try in Sheet1, Cell H3 the formula of:

=VLOOKUP([@Director],Table4[#All],2,FALSE)

Is that what you were looking for?

[Haseeb Avarakkan]

H3, copy down.

=IFERROR(VLOOKUP([@Director],Table4,2,0),"")

[makkystyle]

AMAZING! Thank you both for the feedback. I'm still a noob when it comes to some of these formulas.