Hi Everyone,
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:
=IF('Sheet1!$D2="","",(VLOOKUP(‘Sheet1!$D2,LIST,5,FALSE)))
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.
E
Bookmarks