index match not working

**chriswrcg** · 07-06-2022, 08:26 AM

I can't figure out why this formula in Q1 is not working.

**Fluff13** · 07-06-2022, 08:32 AM

It's because you have #N/A errors in col C, try this instead

Formula:

=IFERROR(INDEX('Punch Log'!$F$2:$F$463,AGGREGATE(15,6,(ROW('Punch Log'!$F$2:$F$463)-ROW('Punch Log'!$F$2)+1)/('Punch Log'!$C$2:$C$463=P1)/('Punch Log'!$D$2:$D$463=O1),ROWS($Q$1:$Q$1))),"")

**chriswrcg** · 07-06-2022, 08:35 AM

Thank you Fluff13

**Fluff13** · 07-06-2022, 08:49 AM

Glad to help & thanks for the feedback.

**Bo_Ry** · 07-06-2022, 08:54 AM

If you only want the first one, please try

=INDEX($F$2:$F$463,MATCH(1,('Punch Log'!$C$2:$C$463=P1)*('Punch Log'!$D$2:$D$463=O1),))

index match not working

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

index match not working

Re: index match not working

Re: index match not working

Re: index match not working

Re: index match not working

Thread Information

Users Browsing this Thread

Similar Threads

Index Match Match for pricing matrix not working

Index Match Match - 2 x Vertical Lookups - Not working as it should

[SOLVED] help index and match macro not working but formula working??

[SOLVED] Working INDEX MATCH with SEARCH, but I need to add another MATCH to the formula!

Correct/Working (Index,Match) formula not working between cells

INDEX MATCH MATCH working great and then failing on me.

INDEX MATCH MATCH working fine and then NOT WORKING for a random row or two.

Bookmarks

Bookmarks

Posting Permissions