Find and compare values in a sheet.

**JonesyCC** · 08-29-2013, 10:38 AM

Hi Everyone

I need a formula that will look at a entire work sheet find a name, then find a date, and display a string from a cell in the date row.

for example I want it to first find all the rows that has "Jane Doe", then find a specific date from those rows, and then display a value from a cell in that row. Keep in mind that the there will be no consistency with the row data, but the column's are static.

help any idea's?

Example.jpg

**benishiryo** · 08-29-2013, 08:53 PM

welcome to the forum, JonesyCC. it's always better if you can upload a sample file instead of a picture. that way, we don't have to re-create your scenario to test it out. i guess you can use this formula in M3:
=IFERROR(INDEX($H$4:$H$100,MATCH(M$2&$L3,INDEX($C$4:$C$100&$D$4:$D$100,),0))&"","")

**Tony Valko** · 08-29-2013, 09:17 PM

Here's another one...

Enter this array formula** in M4:

=IFERROR(T(INDEX($H$4:$H$9,MATCH(M$2,IF($D$4:$D$9=$L4,$C$4:$C$9),0))),"")

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

Copy across to N4 then down as needed.