comparing 2 sheets
keyur wrote:
sorry just out of curiosity, what if i have more than 2
columns with only part # to compare so say
part # description1 description2
descripion3......
what would i have to add to the formula to fill them in too
VLOOKUP(arg1,arg2,arg3,[arg4]) has 4 arguments (last one is optional).
arg1 = cell to be matched.
arg2 = Matrix where the first column has the cell to be matched.
arg3 = Column to be returned.
arg4 = true or false (0 or 1) if the list is ordered or not (default=1).
Now if you have a wider matrix, you just tell wich column number to be
returned in arg3. If description2 is in column 10 of the matrix, replace
the 2 in the previous formula by a ten. Each formula will return just
one field, so if you want more than one description you'll need to copy
the formula and change it to suit your needs.
Regards,
PS: This is explained in the help file (I suppose it should).
--
Beto
Reply: Erase between the dot (inclusive) and the @.
Responder: Borra la frase obvia y el punto previo.
|