If Match in Column, Col 2 If Not Col 4

[Jimmy D]

Column 1 Column 2 Column 3 Column 4
11111 $2.80 11111 $2.00
10000 $4.00 10500 $300.00
12345 $29.00 12345 $20.00

• If the part number in column 1 has a match in column 3, then use the LIST price in column 2.
• If there is NO match for a part number in columns 1 and 3, then use the LIST price in column 4

.Excel 2007/Windows 7 Pro

 

[Scott Huish]

If you mean if there is a match in the same row, then:
=IF(A1=C1,B1,D1)