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 |
All times are GMT +1. The time now is 12:04 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com