Home |
Search |
Today's Posts |
#1
|
|||
|
|||
FIND DATA WITHIN DATA (V-OR-H LOOKUP/FIND/MATCH?)
HELLO,
IN A WORKBOOK NAMED RECIPEC I ENTERED 5 SHEETS CONTAINING 5 DIFFERENT RECIPES IN EACH SHEET. EACH SHEET CONTAINED, COLUMN A; VOLUME OF INGREDIENT, COLUMN B NAME/DESCRIPTION OF INGREDIENT. IN THE LAST SHEET (6) I LISTED, IN COLUMN A, ALL INGREDIENTS USED IN ALL RECIPES (SHEETS), AND IN COLUMN B I WOULD WANT TO HAVE A FORMULA WHICH WILL RETURN HOW MUCH (SUM) OF THAT INGREDIENT I WILL NEED BASED ON A TABLE IN SHEET 6 WHERE I CAN SELECT (THROUGH A DROP DOWN LIST) WHICH AND/OR HOW MANY RECIPES (SHEETS) I AM DOING .. THANKS IN ADVANCE, JAY |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I compare data in two worksheets to find matching cells? | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Find repeted data??? | Excel Discussion (Misc queries) | |||
Another question on how to find duplicate data | Excel Worksheet Functions | |||
I need a macro to find cut and paste data to new cell | Excel Discussion (Misc queries) |