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