mathcing and comparing
 

i have 2 spreadsheets with 5 column of data on each, on one workbook, w
will call booka,in column c there are part numbers and column f i
quantity. what im trying to do is take the parts numbers and match the
to another set of part numbers on the second book(bookb), and paste th
quantity of that part number next to the qauntity on bookb which i
column as well. i dont need the part numbers to show, im just trying o
match the quantities next to each other and the part numbers arent i
order. so if the way i described is easy or another way is easier.
tried multiple things but just can seem to get it to work. also some o
the part numbers arent even there so those will be skipped. also,. som
of the part numbers dont match, which it would be nice if those can b
highlighted or something, or anything that makes them stand out. bu
basically i just want the first function, mathcing the part numbers t
compare quantities. thanks for any help

--
Message posted from http://www.ExcelForum.com

mathcing and comparing
 

vlookup assumes the value to match is in the leftmost column of the range.
This fits your criteria, so there is no reason to use Index and Match which
are equivalent, but don't have this restriction. Bernie has added an
additional test to see if there will be a match and thus suppress the #N/A
which is returned by default. You can prepend that test to the vlookup as
well if you want that.

--
Regards,
Tom Ogilvy

"derekc " wrote in message
...
im about to eat lunch, i will try both and get back to both of you as
soon as i can. thanks a bunch.


---
Message posted from http://www.ExcelForum.com/

mathcing and comparing
 

i tried bernies, it came no match everytime , even if there was
match.

toms gave me a na everytime, this thing hasbeen a pain

--
Message posted from http://www.ExcelForum.com

mathcing and comparing
 

bum

--
Message posted from http://www.ExcelForum.com

mathcing and comparing
 

Vlookup is pretty basic. #N/A means it didn't find a match.

Note that the string 123 does not match the number 123.

I don't know if that has any bearing on your problem.

--
Regards,
Tom Ogilvy

"derekc " wrote in message
...
bump


---
Message posted from http://www.ExcelForum.com/