Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup when have 2 or more criteria to meet
I have a huge database with the sales of different product lines and regions
and I need to extract the key lines by region for the corresponding period. vLookup is just bringing the first "world" in the database so if I want to have the value for world for "cosmetics" as well as world for "analgesics". (Criteria Region and Criteria Product Line) I'm not a heavy excell user....so I guess I have to combine to functions how can I do it?? HELP!!!!! Column # 1 2 3 4 5 Prior Year Budget Actual World Cosmetics $XX $XX $XX World Analgesics $XX $XX $XX Europe Cosmetics $XX $XX $XX Europe Analgesics $XX $XX $XX Asia Cosmetics $XX $XX $XX Asia Analgesics $XX $XX $XX |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add text to meet criteria | Excel Worksheet Functions | |||
count rows that meet certain criteria | Excel Discussion (Misc queries) | |||
add numbers if they meet criteria...? | Excel Worksheet Functions | |||
How to calculate how many meet min and max criteria | Excel Worksheet Functions | |||
Count Cells that meet Criteria | Excel Worksheet Functions |