CODEWITHSUNDEEP
excel
Andy K
Andy K

Reputation: 5075

2 cells , which match 2 columns in excel

I'm trying to see if 2 cells C2, exist in the column G and H in the same order.

If yes, it will bring back the relevant cell in the F column.

However, it is not working as expected.

I've got this error message #VALEUR!

This is the formula I've used 

 =INDEX(F2:F60000;EQUIV(C2:D2;G1:H60000;0))

Any suggestions are welcomed.

I don't think I need VBA but it may be the case, although I hope not.

enter image description here

Upvotes: 0

Views: 41

Answers (1)

cooldude
cooldude

Reputation: 86

You can do it via a simple IF Condition like

=IF(C2=G2,IF(D2=H2,F2,"False"))

Upvotes: 1

Related Questions