Hello;

I am doing a simple function. I can't believe I have been trying to get this
to work for two hours. I know it's probably something stupid, so here goes.

=VLOOKUP(C3,ProductList,10,FALSE)

This formula is returning #n/a.

ProductList is a named range on sheet 1. It refers to cells 'Product
List!'$a$2:$j$1000. I had renamed the sheet 1 to "Product List". I renamed
the worksheet again, hoping it was a bug, to the letter a. No luck.

C3 is my qualifier. I have to qualify based on two criteria. IE all "Black"
and "10 oz" or "Pepsi" and "1 liter". I have come up with a workaround for
the vlookup by using a helper cell and concatenating the values. C3 is
concatenated from A3:B3 and the helper cell in my table concatenates the
same, relative, information from the table. So I am searching the same value.
Can vlookup lookup the values of cells that occur during concatenation? I
just tried switching from the concatenated cells to static reference cells
and still get the #n/a error.

10 is the column I am looking for the information for
False, Exact reference.

I have tried naming the table cells directly, naming fewer cells, deleting
the named range and selecting the table. Nothings working. Maybe fresh eyes
in the morning:)

Help, Please

God Bless

Frank Pytel