lookup & match solutions
 

i don't even know if there's a way to do this but:

i have to update an inventory list twice a week using two files. i
have my template - which lists only certain items - and a report which
i extract from our inventory database (basically a list of all items
and qty's associated with each item).

i would like to search within the extracted file for just the items
(say, in column a)on my template and return the number value (column b)
once it finds a match.

so my lookup_value will actually have to be a combination of the name
and color. so if i'm trying to match the item \"funnyshirt\", it
actually has to match the color too (i.e. \"funnyshirt\" in the color
blue\").

can i insert some sort of and function so that the lookup_value will be
funnyshirt and blue referenced by two cells, a1 and b1???

help!


--
ieatboogers
------------------------------------------------------------------------
ieatboogers's Profile: http://www.excelforum.com/member.php...o&userid=28820
View this thread: http://www.excelforum.com/showthread...hreadid=485719