Index Match formula help

[AdiLungu]

I have all sales stacked into one column and need to asign sales to the hour (F1:AC1), tried =INDEX(Labor!$F$1:$AC$1,MATCH($K4,Labor!$F:$AC,0)), where Labor is F:AC and K4 is 406.29 and it didn't work, returned #N/A. Then tried =xlookup($K4,Labor,Hours) with Hours is F1:AC1, didn't work either.

Your help and support will be highly appreciated.

Thank you

 

[mrshl9898]

So this is the table you want to populate in 'Labour'? What does the other table look like? Sounds like a job for SUMIFS.

 

[AdiLungu]

So this is the table you want to populate in 'Labour'? What does the other table look like? Sounds like a job for SUMIFS.

In hour24 column hour of sale needs to match sales, e.g. 406.29 was posted for 5 PM.

 

[mrshl9898]

Is the number for the hour stored in the columns? Will CallWeekDay populate in each row?

Then why is 406.29 unique? There are 3 other values for Tuesday in the 16 column. What are the other qualifiers? Or why is that value selected?

Also when including data please include the Sheet name as well as the Column and Row references (like in your opening post).