• Sign in to Neowin Faster!

    Create an account on Neowin to contribute and support the site.

  • 0
Sign in to follow this  

Help a noob with EXCEL lookup function

Question

webeagle12    948

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!

 

 

Share this post


Link to post
Share on other sites

2 answers to this question

Recommended Posts

  • 0
webeagle12    948

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.... 

Share this post


Link to post
Share on other sites
  • 0
BGM    101

file link seems to not work... 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.