vlookup in multiple worksheets

Hi, I am trying to vlookup working across multiple sheets. I have the worksheet name in cell C12 (this value will vary). The value I want vlookup to search for is in cell F12. In the targeted worksheet I want vlookup to look in column 1 for the value "A" and return the value in column 2 of the same row.

Ideally I would like this formula to work across multiple files or maybe just search multiple worksheets on a single seperate file. Anyways, the value in C12 points to the worksheet or file that I want vlookup to use.

I thought a combination of indirect and vlookup would work but I can't get it to fuction correctly. Here is what I have so far. I have the IF function because I have both an "A" and an "a" value that vlookup must see differently.

=INDIRECT(C12&"!"&"IF(F12=0,"",IF(EXACT(F12,VLOOKUP(F12,A9:B162,1,FALSE)),VLOOKUP(F12,A9:B162,2,FALSE)*1000,VLOOKUP(F12,A35:B60,2,FALSE)*1000)")

Any help you have is greatly appreciated

I think this will do. Thanks a million!

that thread was very helpful, but do the different tabs you want to pull from need to be in the same workbook as the "data" tab?

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.