use a combination of INDEX and MATCH instead
where A1 contains the item number that you're looking for
and B1 contains the name of the customer you're interested in
Hope this helps
"Doug" wrote in message
I want to search in a table for a specific value. I have a table with item
numbers in column A going down rows 10:200 and the customers names going
across the columns B:K ...
I have a list of sales transactions in anouther worksheet with the
... I want to lookup the price for an item for a specific customer. So I
a vlookup to find the row with the appropriate item number (I can do that)
and I need a hlookup to find the correct customer (I can do that) ... the
problem is that I can not seem to do both in one formula. Can anyone help?