IF/VLOOOKUP - Multiple Tabs

[casdaq]

Hi - I'm using the below formula to pull in results from multiple tabs - but i need to add an "IF" Function in if the name I am searching for is not listed on any of the tabs. Any help is appreciated!

=VLOOKUP($B138,INDIRECT("'"&INDEX({"IFP-CM";"OFP-CM";"CDS-CM";"CRT-CM";"LNG-CM";"TECH-CM";"WSC-CM"},MATCH(1,--(COUNTIF(INDIRECT("'"&{"IFP-CM";"OFP-CM";"CDS-CM";"CRT-CM";"LNG-CM";"TECH-CM";"WSC-CM"}&"'!$a2:$a200"),$B138)>0),0))&"'!a2:z200"),3,0)

[Cutter]

Probably time to add some detail to your profile since the answer will depend on what version of Excel you are using.

[casdaq]

I'm sorry - I am using excel 2007. Please let me know if there is anything else you need to know.

[Cutter]

Since you're using Excel 2007 you can use IFERROR()

so:

=IFERROR(your current formula here,"")

This will make the cell appear blank when your VLOOKUP() results in an error (like #N/A)