XLookup against multiple lookup values?

[crtk09]

Hi all,

Is there an "or" function per-se for lookup values under XLookup? Below I have a table that has a couple of different name combinations. I would like to be able to lookup both name variations in the table below (Preferred name column AND the reverse name column) and then return the employees time logged data, which I have data for sat in a pivot table.

E.g. =XLOOKUP(A6 OR B6,'Pivot 2022-01'!A:A,'Pivot 2022-01'!B:B,"0",0)

Preferred Name	Reverse Name	Function from Org Assignment	Department from Org Assignment	Worker's Manager	Location	Management Chain - Level 03	Jan Hours Logged	Jan % Time Logged	Feb Hours Logged	Feb % Time Logged	Mar Hours Logged	Mar % Time Logged	Apr Hours Logged	Apr % Time Logged
Aaron Smith	Smith, Aaron	R&D	Tech R&D	Keith Dimond	UK	Bob Jones	22.6	15%	7.2	5%	31.7	18%	71.60	50%

 

[Domenic]

Try . . .

=XLOOKUP(A6,'Pivot 2022-01'!A:A,'Pivot 2022-01'!B:B,XLOOKUP(B6,'Pivot 2022-01'!A:A,'Pivot 2022-01'!B:B,"0"))

Hope this helps!

 

[crtk09]

Try . . .

=XLOOKUP(A6,'Pivot 2022-01'!A:A,'Pivot 2022-01'!B:B,XLOOKUP(B6,'Pivot 2022-01'!A:A,'Pivot 2022-01'!B:B,"0"))

Hope this helps!

Thank you Domenic!! This was exactly what I needed, and works perfectly.

 

[Domenic]

You're very welcome, glad I could help.

Cheers!