Oct 03 2020 09:50 AM
I have these two workbooks. Previously I have used INDEX / MATCH (5x times) to get the desired effect that I want, is there a specific set of formulas which I can use to get multiple values from the member number to get the five entries which I need to fill out. Thank you.
Oct 03 2020 11:21 AM
I guess you need to fill data into the 5 columns to the right of each ID. Not sure why INDEX/MATCH or similar doesn't work - formula will be populate within the column automatically and with proper designed formula you only need to drag it to the right to fill other columns.
Oct 03 2020 01:04 PM
Oct 03 2020 01:52 PM
Afraid I didn't catch, copy/paste formula to another 5 columns is just few seconds second.
I assume formula is like
=INDEX(Table1[[Forename]:[Zip Code]],
MATCH(Table2[@[MemberNo]:[MemberNo]],Table1[[MemberNo]:[MemberNo]],0),
COLUMN()-COLUMN(Table2[[#Headers],[MemberNo]]) )
another columns are empty at the beginning, then with copy/paste they shall be filled (don't drag)