Hi all. I'm using an Index-Match-Match and one of the Match functions consistently returns an N/A for me. In the attached file I've highlighted the Match values that should in theory return '1' for the row reference, but is returning an N/A instead.
Can anyone see why this is happening? Thanks in advance!
Can anyone see why this is happening? Thanks in advance!