mjordan2005
New Member
- Joined
- Mar 27, 2017
- Messages
- 1
Hello,
I have read numerous posts over this situation, but I have been unsuccessful in solving my dilemma. I want to create an Index (Match) (Match) formula over a series of 116 sheets within the same workbook. My primary sheet (containing the formula), has all of the part numbers (Lookup value for row) in Column A. A part number will only occur once in the sheets that I plan to lookup information from.
What is the most efficient way to do this?
I have read numerous posts over this situation, but I have been unsuccessful in solving my dilemma. I want to create an Index (Match) (Match) formula over a series of 116 sheets within the same workbook. My primary sheet (containing the formula), has all of the part numbers (Lookup value for row) in Column A. A part number will only occur once in the sheets that I plan to lookup information from.
What is the most efficient way to do this?
