Forum Discussion
Lookup & Reference
Need some help formulating this one... If I have a site in either the F "or" G column I need the corresponding region identified in the H column. I have the XLOOKUP in the H column but currently it'...
Cross-posted at https://answers.microsoft.com/en-us/msoffice/forum/all/lookup-reference/3fa39c5e-1888-4577-a1a1-134414b42262
I replied there:
=XLOOKUP(F2, 'Other Tab'!$B$2:$B$1000, 'Other Tab'!$C$2:$C$1000, XLOOKUP(G2, 'Other Tab'!$B$2:$B$1000, 'Other Tab'!$C$2:$C$1000, ""))