Resolved >>> Reverse Lookup (Index & Match)

**SamuelT** · 10-23-2007, 12:22 PM

Hi all,

The best way to describe this problem is to show you...see attached!

Basically what I'm trying to do is (in column L) find which column the figure in column K appears in the preceding columns, then look in row 9 and return the month when this was charged.

Any ideas on how to do this? I need some kind of reverse HLOOKUP-type function!!!

TIA,

SamuelT

**Ron Coderre** · 10-23-2007, 12:35 PM

Please Login or Register  to view this content.

Is that something you can work with?

**SamuelT** · 10-23-2007, 12:44 PM

That works perfect. Thank so much Ron.

**BetoLeTater** · 02-21-2014, 05:48 AM

Vacation 20FEB14.xlsmIm trying to do a similar thing.

I would like to look up a specific name in the table and once found, display the Date located in column A. is this possible?

Any help would be much appreciated! thanks!

PS. I love this forum!

**Pete_UK** · 02-21-2014, 05:53 AM

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

Pete