Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
mathcing and comparing
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
comparing | Excel Discussion (Misc queries) | |||
comparing | Excel Worksheet Functions | |||
Comparing more than two | Excel Worksheet Functions | |||
comparing from two worksheets | Excel Discussion (Misc queries) | |||
Comparing | Excel Programming |