Forum Discussion
Index match
Hello, I am trying to do the following using 3 different sheets. The first sheet (see picture 1) contains the info on ID and Number. The second file contains the info on Number and Chain (see picture...
Muza16 Perhaps a double VLOOKUP will do what you need.
I've used some named ranges to avoid long and direct references including sheet names. File attached.
Edit: Attached wrong file and screenshot. Fixed now.