Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match data in 2 columns and return data from 3rd column
I know I have done this in the past but can't remember how I did it.
I have my main spreadsheet, customer.xls with zip and weights. Column A Column B Zip Wt I have a second spreadsheet, prices.xls that has zip, weights and dollar amounts. I can't copy and paste because this spreadsheet is only for shipments weighing less than 200 lbs. Column A Column B Column C Zip Wt $ I need the following, If the zip and weight on the customer.xls is the same as the zip and wt on the price spreadsheet then return the $ on the customer.xls. Can anyone help? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
counting data in one column and match with data in another column | Excel Discussion (Misc queries) | |||
LOOKUP two data sets for match - return 1 or 0 - Please help! | Excel Worksheet Functions | |||
match columns and associated data | Excel Discussion (Misc queries) | |||
MATCH UP DATA IN COLUMNS | Excel Worksheet Functions | |||
Match Each Numeric occurrence and Return Individual Rows of Data | Excel Worksheet Functions |