HLookup has stopped working

[smiffydotnet]

I had an HLookup, which would pull data from Row 17 if it found "June2020CC" in the array.

I'd run this over several rows to pull over subtotal for each category on my June 2020 Credit Card sheet.

All was fine, but then for no apparent reason, it started to pull in the next column over i.e. not the one headed June2020CC, but the column to the right!

Reading the threads it's suggested to use INDEX and MATCH instead, but I can't get my head around this.

This is my current formula

=HLOOKUP($M575,MonthEndValues,R576)

M575 contains the key i.e. JUNE20CC
R576 is the row number, in this example 17

So what I'm wanting to do is to pull over the value from Row 17 of the MonthEndValues array, where the column row contains "JUNE20CC"

 

[steve the fish]

Try this:

=HLOOKUP($M575,MonthEndValues,R576,FALSE)

 

[smiffydotnet]

@steve the fish Thanks - worked a treat