VLOOKUP Nesting Formulas

A

ajpowers

When I say "there" I mean the data range I'm searching. I'm starting t
think that a vlookup isn't the way I should be going. The purpose o
this formula is to tell me if a specific item number that is on
specific purchase order is on a boat from China yet.

Container PO# Part# Cases Pieces
CAXU9144316
P900686 66701 215 2,580
P900608 68301 615 7,380
P900686 68301 1267 15,204
P900686 69501 74 888
P900686 77501B 9 432
P900686 77901 145 580

I could be looking for item #77001 that is on PO#P900686, but if
don't specify in the formula both numbers have to exist, the resul
will be TRUE because the PO number in on this container
 
R

RagDyer

You could try this:

=AND(A1<>"",B1<>"")*(SUMPRODUCT((E50:E100=A1)*(F50:F100=B1)))

This will give you a *count* of the number of times a match is found between
A1 & B1, and Column E & Column F.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


When I say "there" I mean the data range I'm searching. I'm starting to
think that a vlookup isn't the way I should be going. The purpose of
this formula is to tell me if a specific item number that is on a
specific purchase order is on a boat from China yet.

Container PO# Part# Cases Pieces
CAXU9144316
P900686 66701 215 2,580
P900608 68301 615 7,380
P900686 68301 1267 15,204
P900686 69501 74 888
P900686 77501B 9 432
P900686 77901 145 580

I could be looking for item #77001 that is on PO#P900686, but if I
don't specify in the formula both numbers have to exist, the result
will be TRUE because the PO number in on this container.
 
Top