Forum Discussion
Solved
XLOOKUP where the lookup value is a formula
Hi, I'm trying to use XLOOKUP where the lookup value is a formula, e.g.,: A7 = Hospitality - P0461 A8 = RIGHT(A7) XLOOKUP(A8, table1.some_column, table1.some_other_column) the XLO...
=RIGHT(A7) returns the rightmost character of A7, i.e. "1"
Does it work if you use =RIGHT(A7,5) ?
=RIGHT(A7) returns the rightmost character of A7, i.e. "1"
Does it work if you use =RIGHT(A7,5) ?
I'm an idiot. I realized after I posted the message that my RIGHT was wrong lol. I tried to delete the post but now everyone gets to know!