Check on value then other if match then show the weight

[studio52]

Hello,

Trying to make a formula, what would do the following in the attached file:

1. Check if AK(Sheet1) = F(Sheet2) if match
2. Check if AL(Sheet1) = G(Sheet2) if match
3. Show in BE(Sheet1) the value of P(Sheet2)

Thank you in advance!

[studio52]

Sorry the first attachment is without the Sheet2 so please check out the new one.

[Spencer101]

Try this in cell BE1 on sheet1:

=IF(AND(AK1=Sheet2!F1,AL1=Sheet2!G1),Sheet2!P1,"")

Is this what you mean?

It stays blank as cells AK1 on sheet 1 and F1 on sheet 2 do not match in this instance. But test it on full data and let us know if it works.

S.

[studio52]

Doesn't work, the cell BE stays empty.

Try this in cell BE1 on sheet1:

=IF(AND(AK1=Sheet2!F1,AL1=Sheet2!G1),Sheet2!P1,"")

Is this what you mean?

It stays blank as cells AK1 on sheet 1 and F1 on sheet 2 do not match in this instance. But test it on full data and let us know if it works.

S.

[Spencer101]

That doesn't mean it's not working. Just means that all the matches required are not met.

As I pointed out, one of the conditions in your original post (1. Check if AK(Sheet1) = F(Sheet2) if match) is not a match, so the blank cell is correct. If these two cells DID match then BE1 would not show as blank.

[studio52]

Sorry, i was away for some time. I have figured it out. The file i have attached here was example of the original with some data. In the end i got a function like that:

=INDEX(data!$F$2:$P$60041; MATCH(AK5&AL5;data!$F$2:$F$60041&data!$G$2:$G$60041;0);11)

That doesn't mean it's not working. Just means that all the matches required are not met.

As I pointed out, one of the conditions in your original post (1. Check if AK(Sheet1) = F(Sheet2) if match) is not a match, so the blank cell is correct. If these two cells DID match then BE1 would not show as blank.