I hope someone can help me with what I think should be a very simple problem:
I’m trying to use the IF function in addition to VLOOKUP using the formula below:
I have used this formula before and it has worked, the only difference now is that the reference cell is in a different tab to the formula.
Should I be using some sort of INDIRECT or OFFSET function with this?
Thanks for any help you can provide.