Using ComboBox with VLOOKUP I\'m not sure what I\'m doing wrong. I\'m trying to

Question

Using ComboBox with VLOOKUP

I'm not sure what I'm doing wrong. I'm trying to create a VLOOKUP. I need to be able to choose the Table Array location based on the output from a Combo Box (Form Control). The location choices will be different tabs, but always the same array cells. Due to restrictions, I am unable to use Macro/VBA.

For example, three possible lookups could be:

What I need is for the "Sheet1", "Sheet2", "Sheet3", etc... to be populated from the Combo Box output.

Any suggestions??

Thanks !!

=VLOOKUP(D4,'Sheet1'!$A$11:$U$530,2,FALSE) =VLOOKUP(D4,'Sheet2'!$A$11:$U$530,2,FALSE) =VLOOKUP(D4,'Sheet3'!$A$11:$U$530,2,FALSE)

Explanation / Answer

Hi..

Hi.

If AA1 is the Country Name, then try this

=VLOOKUP($BB$31,INDIRECT("'"&AA1&"'!!A11:U250"),2,FALSE)

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.