• 0

Help a noob with EXCEL lookup function


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 post
Share on other sites

2 answers to this question

Recommended Posts

  • 0
webeagle12

Also forgot to say the data in Sheet Mon Columns F and N will not be "row static", sometimes number "2" will be in row, sometimes in row 5 etc.... 

Link to post
Share on other sites
  • 0
BGM

file link seems to not work... 

Link to post
Share on other sites
This topic is now closed to further replies.
  • Recently Browsing   0 members

    No registered users viewing this page.