Excel - Where did VLOOKUP find it?

  powerless 15:19 09 Jan 2011
Locked

I have an excel spreadsheet that has several worksheets. On my first sheet (Summary) I have a bunch of numbers that I need to return some information on. This information is on one of the other sheets (Data1, Data2, etc).

I can use =IF(ISNA(VLOOKUP( etc to go and find the information on the other sheets; it will look in the first sheet (Data1) and if it did not find anything it will then go and look in the second sheet (Data2) and so on until it finds it or not.

Is there a way for excel to return the sheet name where the VLOOKUP found something?

  powerless 21:58 09 Jan 2011

Hi Vog,

I've got it all in and am not getting any errors but it's not working. It keeps returning the Summary page sheet with the value I am looking up.

See example: htpp://click here

  powerless 22:00 09 Jan 2011
  powerless 22:02 09 Jan 2011

I should say I've tried a few iterations of the VLOOKAllSheets not just what is shown in the file.

  powerless 13:42 10 Jan 2011

OK I figured it out.

"Where "Dog" is the value to find"

I was pointing it to a cell on the summary sheet, so it's now working.

But I need to point it to a cell on the summary sheet, can this done?

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Last Chance: Win an Honor Band 5

Acclaimed illustrator James Jean's comic book past gets celebrated in new book

Best Apple tech gifts for Christmas 2019

Noël (2019) : idées cadeaux & guide d'achat !