I
ieatboogers
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!
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!