| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match 2 criteria with 2 criteria
I am looking for a function that will look at 2 criteria and then match the 2
on the other sheet to get the margin/ price. In B and C, I have the market and product type. Following those is the pricing based on different pricing groups (which have a different percent off list depending on who you are). On sheet 2, I have market and product type in A and B. These are followed by the percent difference between the price groups. I want to be able to reference sheet 2 matching the market and product type to bring over the correct price. Any assistance would be excellent. Thank You!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match 3 Criteria and Return Lowest Numeric Value | Excel Worksheet Functions | |||
| Count rows that match 3 sets of criteria? | Excel Worksheet Functions | |||
| How can I retrieve multiple rows that match one criteria, i.e. a d | Excel Worksheet Functions | |||
| Match 2 Criteria | Excel Discussion (Misc queries) | |||
| Find a match that;s not exact | Excel Worksheet Functions | |||
Threaded Mode
