Jun 14 2022 09:48 AM
Hi.
I need to INDEX MATCH across multiple sheets. I have an amalgamated set of coordinates in one cell. This will match amalgamated coordinates in other cells across multiple sheets (6 in total). Once the match is completed I need to return a value that corresponds to that match.
So, if a1 matches 'sheet1'a1 index b1. Any help is appreciated and happy to give further information.
Thanks,
Alfie
Jun 14 2022 01:40 PM