Lookup or Match

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Doug - 22 Jun 2004 19:45 GMT

I have a sheet with inventory, col (A) material Col (B)
description and Col (C) Part Number.
I also have a sheet that does a Bill Of Materials.
It gives material and description. I need to lookup the
material and match it to the description and retun the
part number. I am stumped.

Reply to this Message

Don Guillett - 22 Jun 2004 20:29 GMT

Have you tried looking in HELP index for vlookup and hlookup and match?
vlookup(a1,lookuptable,2,0)
will lookup whatever is in cell a1 in column 2 of the table you created. the
0 is the same a false in the examples in help.
match will find the row in a colum of the sought item
=match(a1,b2:b200) to find the row
then use
index (look in HELP) to combine with match.
This is how we learn.

Signature

Don Guillett
SalesAid Software
donaldb@281.com

> I have a sheet with inventory, col (A) material Col (B)
> description and Col (C) Part Number.
> I also have a sheet that does a Bill Of Materials.
> It gives material and description. I need to lookup the
> material and match it to the description and retun the
> part number. I am stumped.

Reply to this Message

Doug - 22 Jun 2004 20:50 GMT

thanx

>-----Original Message-----
>Have you tried looking in HELP index for vlookup and hlookup and match?
[quoted text clipped - 15 lines]
>
>.

Reply to this Message