If Value in a range of cells equals X, then echo value (name) in another range of cell

**tonytorero** · 01-23-2013, 12:23 PM

Excel 2010 challenge I'm requesting some neuronal activity help with...

If a Value within a range of cells equals "X", then return the unique value (name) in another range of cells.

Any help is appreciated.

Regards,
T.

**dilipandey** · 01-23-2013, 12:37 PM

Hi Tony,

Welcome to the forum.

then return the unique value (name) in another range of cells.

not clear... lets say a1:c5 has "X", then you need a unique name from another range lets 'say d1:d5 .. correct ? OR you have some other point ?

Regards,
DILIPandey
<click on below * if this helps>

**tonytorero** · 01-23-2013, 12:41 PM

Thanks for the request for clarification. Your understanding of the function of the formula I aim to build is correct.

Best,
T.

**Brumbot** · 01-23-2013, 12:42 PM

=INDEX(Range of values to return, MATCH(Value to lookup, Range of values to look in, 0))

^ Use that syntax and it should work.

e.g. Using dilipandeys ranges:

Please Login or Register  to view this content.

Hope this helps.

**tonytorero** · 01-23-2013, 12:52 PM

Thank you for the quick reply. Tremendous answer that met my need perfectly! Just discovered this forum. Hope to add value (besides taking it!) as well!

**Brumbot** · 01-24-2013, 04:40 AM

Originally Posted by tonytorero

Thank you for the quick reply. Tremendous answer that met my need perfectly! Just discovered this forum. Hope to add value (besides taking it!) as well!

You're welcome. Enjoy the forums!

If you believe that your query has been solved, please mark the thread as 'solved' by clicking on 'thread tools' > 'mark as solved' at the top.

**bwmuhich** · 09-03-2013, 06:23 PM

I registered for this forum a few minutes ago just to post a thank you as this was the exact formula I'd been search for!

THANK YOU!

If Value in a range of cells equals X, then echo value (name) in another range of cell

LinkBack

Thread Tools

Rate This Thread

Display

If Value in a range of cells equals X, then echo value (name) in another range of cell

Re: If Value in a range of cells equals X, then echo value (name) in another range of cell

Re: If Value in a range of cells equals X, then echo value (name) in another range of cell

Re: If Value in a range of cells equals X, then echo value (name) in another range of cell

Re: If Value in a range of cells equals X, then echo value (name) in another range of cell

Re: If Value in a range of cells equals X, then echo value (name) in another range of cell

Re: If Value in a range of cells equals X, then echo value (name) in another range of cell

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions