Forum Discussion
Please help with XLOOKUP error
Hi, I'm trying to find the PO value in sheet 1 that meets multiple criteria using sheet 2. (Sorry, I am not able to upload the sample file due to the policy.) Sheet 1 Sheet 2 ...
Colinahn Try this one;
=IFERROR(XLOOKUP($A2&C$1,'Sheet 2'!$C$2:$C$6&'Sheet 2'!$B$2:$B$6,'Sheet 2'!$A$2:$A$6),"")Replicated your file to demonstrate. See attached.