If Match in Column, Col 2 If Not Col 4

Jimmy D

New Member
Joined
Sep 9, 2014
Messages
1
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
 

Some videos you may like

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

Scott Huish

MrExcel MVP
Joined
Mar 17, 2004
Messages
19,955
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
If you mean if there is a match in the same row, then:
=IF(A1=C1,B1,D1)
 

Watch MrExcel Video

Forum statistics

Threads
1,109,551
Messages
5,529,474
Members
409,884
Latest member
Msinmath
Top