B2:B5000 = A2 & H2:H5000 = "P" if both the condition satisfied then
u want "Payroll" , if not "Debit order"

use this formula =IF(B2:B5000=A2,IF(H2:H5000="P","payroll","direct
order"))
not just enter, use Ctrl + Shift + Enter

or u want B2 = A2 and H2 = "P" then get payroll or debit order
B3 = A2 and H3 = "P" then get payroll or debit
order. ????

use this formula =IF(AND(B2=$A$2,H2="P"),"Payroll","Direct order")



On Oct 19, 6:16*pm, EricB wrote:
I am trying to obtain a text answer with following:
=SUMPRODUCT(--('Raw Data '!B2:B5000=A2),--('Raw Data
'!H2:H5000="P"),"Payroll","Debit Order")

I am getting a #VALUE error.

EricB