VLOOKUP with table array/sheet wildcards

[MarginalDPS]

Hello all,

I'm certain this is out there somewhere, but I've done a lot of searching and can't seem to find a solution for this VLOOKUP question. Although, there's also a strong possibility that I'm misunderstanding the available information...

I'm trying to do a VLOOKUP using a specific lookup value on one sheet, and I need for it to search a range of cells in another sheet that doesn't always have the same name.

=VLOOKUP(A2,"*"&ExportedData_&"*"!A:E,5,FALSE)

I imagine (hope) there is a painfully simple answer.

Thank you!

 

[AhoyNC]

Try:

=VLOOKUP("*"&A2&"*",ExportedData_!A:E,5,FALSE)

 

[MarginalDPS]

Try:

=VLOOKUP("*"&A2&"*",ExportedData_!A:E,5,FALSE)

Thank you so much for the suggestion, AhoyNC! Unfortunately it's a no go. The ExportedData tab name is always followed by a random set of numbers (Ex: ExportedData_233422, ExportedData_9457827, ExportedData_2973334, etc.). So I think it needs to account for that inconsistency.

 

[steve the fish]

You could have the lookup value in A1 and the sheet name in B1 using this:

=VLOOKUP(A1,INDIRECT("'"&B1&"'!A:E"),5,0)

 

[MarginalDPS]

You could have the lookup value in A1 and the sheet name in B1 using this:

=VLOOKUP(A1,INDIRECT("'"&B1&"'!A:E"),5,0)

This worked! Thank you very much, steve the fish!