On Mar 2, 12:01*am, "Max" wrote:
If you still receive #N/A despite correctly array-entering the formula, and
it looks like there should be matches, then it could be that the source data
and/or lookup data contains extraneous white spaces which is throwing the
matching off.

We could try wrapping TRIM in the earlier expression,
viz array-entered in F3, copied down:
=IF(OR(TRIM(D3)="",TRIM(E3)=""),"",INDEX(C$3:C$100 ,MATCH(1,(TRIM(A$3:A$100)*=TRIM(D3))*(TRIM(B$3:B$1 00)=TRIM(E3)),0)))

Attached is a sample with the above implemented & wroking fine for easy
reference:http://www.freefilehosting.net/download/3d0m7
index n match on 2 col criteria.xls
--
Max
Singaporehttp://savefile.com/projects/236895
xdemechanik
--- *

I have the formula working. It was as simple as C-S-E within the
formula box. I made some tweaks to properly reference columns and
number of rows within a column, but now I have another question.

I have moved my Vendor Table of Items (columns: vendor, Item,
description and price) to a different worksheet within the same file
and successfully referenced that worksheet (allowing me to keep my
price list in a separate worksheet for updating, etc. Please help
with the following. Once the formula looks up the proper Item, I want
to grab the price of that item which is in a column adjacent to that
item look-up and place it in my new table on the dsame row but
different column. So, for each Item looked up there is a
corresponding Price (like $423.00).

I suspect this formula is simpler and I still want to use the
=IF(OR(A6="",B6="") so the cell is blank unless there's a value. Can
you help me with that new formula for the Price column?