Hi,
Please can you help me with the begining of this formula:
=IF(VLOOKUP(A2,Sheet3!$A$2:$E$29,4,0),VLOOKUP(A2,Sheet3!$A$2:$E$29,4,0),IF(OR(D2="Ultimate Parent",D2="Independent Company"),A2,IF(AND(OR(AF2="England",AF2="Wales",AF2="Scotland",AF2="Northern Ireland"),T2<>""),T2,AD2)))
What I want it to do is: IF A2 is found in Sheet3!$A$2:$E$29, then VLOOKUP(A2,Sheet3!$A$2:$E$29,4,0)
Thank you
Bookmarks