Need to match multiple cells

[stags81]

Hello,

I'm looking to create a formula or VBA function in which multiple conditions are met. Here are the columns (Row 1 will be for headers) and the type of data in each column. I'm starting with B2 as an example, but I'm looking to paste the same formula throughout column B.

A2. Transaction #
B2. (will contain the formula)
F2. number
G2. number stored as text
H2. number
I2. Transaction #
N2. number
O2. number stored as text
P2. number

Basically, in column B I need to input a formula that searches the range of N2:P65000 (i.e. the end) to find a matching row in which F2=the value in N, G2= the value in O, and H2=the value in P. If a row is found, it would return the value in column I. For now, I can return "ERROR" if there aren't any matching rows found in that range.

Can you assist? Thanks!

 

[danzon]

assumes that your VALUE in column I is a NUMBER...

it also assumes that there will be only one row out there that matches all criteria

=SUMPRODUCT(--(N2:N65000=F2),--(O2:O65000=G2),--(P2:P65000=H2),I2:I65000)