Formula other than VLOOKUP to search and return a Value

[hammer2]

Hi Folks
I do not wish to use VLOOKUP for this one as I do not want to sort the data-

Example Workbook attached.

Cheers
hammer

[AliGW]

You do not need to order a table for VLOOKUP if you are looking for an exact match, which is what you are doing: that's only where approximate matches are required.

However, INDEX MATCH will probably be more efficient here. In M1 copied down:

=INDEX(STATS!$O$1:$O$13,MATCH(DAILY!L1,STATS!$A$1:$A$13,0),0)

Change the ranges to suit.

[hammer2]

'You must spread some Reputation around before giving it to AliGW again.'

If I had Ali as my teacher all those years ago my attendance rate at school would have doubled from 6 days per annum to 13......

Thank you once again Ma'am

[AliGW]

You're welcome!

I wish I could say that my pupils felt the same way ...