Vlookup with multiple conditions?

  • Thread starter Thread starter Diane
  • Start date Start date
D

Diane

Hi,
Does anyone know if it's possible to use a vlookup based
on multiple conditions?
Example:
I have a master customer sheet that will pull sales from 3
other sources. In the source, the customer could be
repeated but for different type of sales:

ColA ColB ColC
COMPANYABC BED
 
Hi Diane
try the following array entered formula (entered with CTRL+SHIFT+ENTER)
=INDEX('sheet1'!$C$1:$C$1000,MATCH(A1&B1,'sheet1'!$A$1:$A$1000&'sheet1'
!$B$1:$B$1000,0))

this returns the values from columns C if Column A+B matches with the
entries in A1 and B1
 
Wow Frank, I didn't even finish my message and you were
able to suggest something.

I guess you understood my problem.
I will give it a try,
Diane
 
Back
Top