What I'm looking for is when I type a number in Sheet 1, it will look for that value in sheet "Mon" F and N columns only, and then return a value that is in A and I column in "Sheet 2" Door column. I also will have some data in "MON" E and M columns that will need to show up in Sheet 2 F columns too.
So pretty much type number "1" in Sheet 2, column K, and it will show data in column C (that was in "Mon sheet" A and I columns) and show data in F (Sheet 2) that was in "Mon sheet" E and M columns
Can't really use vlookup function and I'm not familiar with Index Match function either so any help I would really appreciate.
Merry Christmas too!!! You guys really help me out last time so hopefully somebody will help me out this time. Thanks!
Question
webeagle12
Here is example excel file.....http://www.filedropper.com/book1_6
What I'm looking for is when I type a number in Sheet 1, it will look for that value in sheet "Mon" F and N columns only, and then return a value that is in A and I column in "Sheet 2" Door column. I also will have some data in "MON" E and M columns that will need to show up in Sheet 2 F columns too.
So pretty much type number "1" in Sheet 2, column K, and it will show data in column C (that was in "Mon sheet" A and I columns) and show data in F (Sheet 2) that was in "Mon sheet" E and M columns
Can't really use vlookup function and I'm not familiar with Index Match function either so any help I would really appreciate.
Merry Christmas too!!! You guys really help me out last time so hopefully somebody will help me out this time. Thanks!
Link to comment
Share on other sites
2 answers to this question
Recommended Posts