Lookup between sheets and pull single value.

[gmaniac]

Hello!

I looked through the forum and I couldn't find what I was looking for. I know that it has to be in here, but the search wasn't working at the moment(recieved this error on search: Fatal error: Allowed memory size of 100663296 bytes exhausted (tried to allocate 1048576 bytes) in /home/eforum/public_html/search.php on line 1012, **Don't worry already forwarded to webmaster).

So here is what I am trying to do, I have an excel that in column A has a person's name and I wanted to be able to look in another sheet for that name and then pull their weight. However, the kicker is that I would like to use the column header to search for which sheet it should pull this information from. And the column header does not match the sheet name exactly, the difference is that the sheet name is "Month, Year" column header is only the "Month."

I have attached an excel with sample data and sheet 4 is where I would like the results to be displayed.

[NBVC]

Try:

=VLOOKUP($A4,INDIRECT("'"&B$2&", 2011'!A:B"),2,0)

Note, A2 is mispelled according to match in the January sheet.... should be: LeVall, Adrienne

[gmaniac]

Nice catch, my girlfriend wouldn't be too happy I misspelled her name. Awesome! You are amazing, works perfectly.