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...
Hello!
If I have understood your requirement correctly then this file might be useful to you!
Feel free to ask for any clarifications in the formula.
Sheet 1
amands_1 Hello. Thanks for the help. But for me it returns the same value for all the rows of Code while I need it to match the chain and number values accordingly. Also, my data in the excel files are not in the same order, they vary, so I need to filter to find each of them in different sheets.
In below screenshot I have entered a number '0' but since number '0' is not available in database in SHEET 2, excel will show error. If number entered in a row of SHEET 1 is present in database in SHEET 2 it will extract chain valve from SHEET 2 using INDEX function and then using chain value and VLOOKUP function it will show corresponding code from SHEET 3.
Also since INDEX and VLOOKUP are used, sequence of data should not matter.
SHEET 1SHEET 2SHEET 3