Look up

[kme]

Kindly Share a Single Formula .

1.Sheet 1 Have Some Sample Customer Data . Different Branches Customer Data are here. Need to Look & Fill Status Colum Through Formula

2.Formula Required in "Column G"

3.Look up data in Sheet 3 "Customer Status"

4.Same customer has balance in different branches. This customer's status varies across some branches.

5.Single formula Required In "Column G"

 

[kme]

Kindly Share a Single Formula .

1.Sheet 1 Have Some Sample Customer Data . Different Branches Customer Data are here. Need to Look & Fill Status Colum Through Formula

2.Formula Required in "Column G"

3.Look up data in Sheet 3 "Customer Status"

4.Same customer has balance in different branches. This customer's status varies across some branches.

5.Single formula Required In "Column G"

6.Look Up Based on Branch Name & Customer

 

[AlanSidman]

Look at this tutorial

XLOOKUP with multiple criteria

The best way to use XLOOKUP with multiple criteria is to use Boolean logic to apply conditions. In the example shown, the formula in H8 is: =XLOOKUP(1,(B5:B15=H5)*(C5:C15=H6)*(D5:D15=H7),E5:E15) XLOOKUP returns $29.00, the price for a Medium Blue Hoodie. Note the lookup_value in XLOOKUP is 1...

exceljet.net

 

[AlanSidman]

Here is a better solution

=XLOOKUP(D4&E4,'Customer Status'!$E$6:$E$15&'Customer Status'!$F$6:$F$15,'Customer Status'!$G$6:$G$15,"not found",0)

 

[kme]

Here is a better solution

Very Thanks