Indexing and collecting information from non adjacent columns in original sheet
I want to pull information from one sheet into another by index match.
The formula has to index the information from either F1 IC / Recommendation, F2 IC / Recommendation or F3 IC / Recommendation by searching for/finding either Recommendation 1 ID No., Recommendation 2 ID No. or Recommendation 3 ID No.
These columns are not adjacent to each other in the origin sheet.
Is this possible?
All assistance greatly appreciated.
Help Article Resources
Check out the Formula Handbook template!