Forum Discussion
Help with an excel formula.
Hello, I have 2 tables on different sheets both containing mobile numbers in colA. (Table 2 has less phone numbers than table 1) Table 1 has user name in col C and address in colD. Table 2...
If you have Excel in Office 2019 or earlier:
=IFERROR(VLOOKUP(A2,Sheet2!$A$2:$E$100,4,FALSE),"UNKNOWN")
and
=IFERROR(VLOOKUP(A2,Sheet2!$A$2:$E$100,5,FALSE),"UNKNOWN")
If you have Excel in Microsoft 365 or Office 2021:
=XLOOKUP(A2,Sheet2!$A$2:$A$100,Sheet2!$D$2:$E$100,"UNKNOWN")
I will try this tomorrow thank you