Everyone has a excel data is not too great god will calculate, suppose a shop have earrings and necklace of stock x and y, b shop has earrings inventory j, c store necklace inventory k, the problem is with the earrings and necklace shops to count in the display counter, at the same time I can only calculate inventory display counter top earrings, could you tell me how to calculate, this data because there is no separate background plus a stage this field, if there is a correlation function or method can judge in excel with earrings and necklace display counter is the store have? Thank you very much!

CodePudding user response:

Ahhh for help

CodePudding user response:

Vlookup function to give it a try

CodePudding user response:

=the if (vlookup (xx& Xx, xx& Xx, 1, 0), ""," ")

CodePudding user response:

The

reference 3 floor quanbudong response:

=if (vlookup (xx& Xx, xx& Xx, 1, 0), ""," ")

Positive solution!