Remember Me?

#1
October 27th 04, 05:03 PM
 Doug Posts: n/a
lookup combine vlookup with hlookup

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 quantity
.... I want to lookup the price for an item for a specific customer. So I need
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?

#2
October 27th 04, 05:10 PM
 JulieD Posts: n/a

Hi Doug

use a combination of INDEX and MATCH instead

=INDEX(A10:K200,MATCH(A1,A10:A200,0),MATCH(B1,A10: K10,0))

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
Cheers
JulieD

"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
quantity
... I want to lookup the price for an item for a specific customer. So I
need
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?

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Abhijeet Excel Discussion (Misc queries) 4 May 19th 05 04:30 AM kg Excel Discussion (Misc queries) 1 January 20th 05 12:53 AM Clay Excel Discussion (Misc queries) 2 January 5th 05 08:35 AM Jeff Excel Discussion (Misc queries) 2 December 2nd 04 02:40 PM Tom Excel Discussion (Misc queries) 4 December 2nd 04 12:44 AM

All times are GMT +1. The time now is 04:35 AM.