vlookup or match function across worksheets ?

  • Thread starter Thread starter Ant
  • Start date Start date
A

Ant

For example I have 15 worksheets in an excel workbook named A through
N. I am looking for the values in worksheet A, Cell A1 (through
A250) across worksheets B through N and return the worksheet name
that the value exists in. (Worksheet C for example) The first or any
exact match is fine. If it doesn't exist #N/A is also fine I can work
with the errors returned myself.

Is this possible? If the worksheet name is too difficult then any
valid result (complete path to cell?) is sufficient.

Thank you
 
Is this possible?

Yes

On sheets B:N, where might the lookup_value be located?

Also, just to confirm, your sheet names *REALLY* are B, C, D, E,.....N?
 
What's the defined name "vowel" for?

Looks like it's a "leftover" and was used to generate your random data.
 
What's the defined name "vowel" for?

Looks like it's a "leftover" and was used to generate your random data.
Click to expand...

Thank you all very much, this was exactly what I needed.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vlookup or match function across worksheets (x-post - sorry) 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Vlookup Reference Certain Worksheets 4
Lookup or VLookup or something else?? 2
MAX across worksheet, return text value 8
VLOOKUP returning #N/A result 2
VLOOKUP HELP 5
Checking for the existence of a worksheet 1

Back
Top