Hot Topics

Excel - Where did VLOOKUP find it?

  powerless 15:19 09 Jan 2011

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

Xiaomi Mi 10 Launches Globally: Price, Release Date, Specs and more

Best Free, Deep Discounted tools for artists and designers 2020

How to get Apple's Final Cut Pro and Logic Pro free

Qwant moteur de recherche par défaut sur les derniers Huawei