Looking up a value in column to return corresponding text on value

L

Lexx Wingspan

Hi,
I'm trying to find a value in column D. The value is 0.000. within 1000 rows
I need the corresponding text in column B & C to appear on a different
worksheet wherever this value appears.

Any ideas? I've no hair left to pull out!

I've been trying a few variations of vlookup but can't get it right

Thanks in advance
 
D

Dave Peterson

Maybe...

=index('sheet99'!c:c,match(0,'sheet99'!d:d,0))
=index('sheet99'!e:e,match(0,'sheet99'!d:d,0))

Change sheet99 to the name of the sheet that contains the values.
 

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

Adding a big matrix in Word 2013 5
Dealing with the error: unable to filter on excel hc home school 0
display '2+2' as '4' in a cell? 5
Formula to check presence of value between sheets 7
Return MAX value from column B and Name from column A 3
a function that deletes all rows with no value in a certain column? 2
Finding Corresponding Cell Value 2
How to look up a value in a list and return multiple corresponding 2

Top