Index Match Offset ::: Trying to pull a value from table.

I have two separate sheets I'm working out of; on sheet1 I have a list of names, in the column next to the names I need to pull a value from Table2 located on sheet2.

The trick is that I need to match the names from my list on sheet 1 with the list from sheet2 table2 and provide me the data from the cell to the right (on table2) corresponding with the name I'm identifying on sheet1

I've tried mixing and matching different iterations of index,match,offset functions but I can't seem to figure out something I thought I would be able to easily figure out. Maybe I'm just running myself in circles and confusing myself by making it harder than it has to be. Please help me out; and thank you in advance.

I tried this as my final (logical) in-cell code (where rbs_2014 is the column in table 2 with the names I'm trying to match from sheet1... but of course it didn't work:

=INDEX(Table2,MATCH(D4,rbs_2014,-1),OFFSET(rbs_2014,0,1))

Use the VLookup function.

TnTinMN,

I've tried Vlookup and I don't get anything close... the sequence of numbers do not follow the names whatsoever, almost as if the data is randomized based on the sets of information in the column I'm targeting for reference.

Quote:

---

Originally Posted by IGPOD

TnTinMN,

I've tried Vlookup and I don't get anything close... the sequence of numbers do not follow the names whatsoever, almost as if the data is randomized based on the sets of information in the column I'm targeting for reference.

---

Without being able to see a sample of data, I doubt that anyone will be able to offer you much advice. If possible, upload a sample spreadsheet. Zip it up first. If you can upload a file, click on the "Go Advanced" button when replying; there are options on that page to attach files to your post.

This does not work?

=index(table2,match(D4,rbs_2014,0))

I'm assuming this is a table with one coloumn of data. And table2 contains numbers. However rbs_2014 contains numbers aswell since you have chosen -1 in the match formula?
Although, if there are several of the same name in rbs_2014 this function will only return the first instance.

If you have more then one coloumn in table 2 you could use this.

=index(table2,match(D4,rbs_2014,-1), match(D4,"x-axis headers",0))

Tho more often then not the -1 crieria on the MATCH formula ruins my day, you could use an if statement for the index/match part in some way maybe. But as mentioned by TnTinMN Some sample data would be needed to give you the best help :)

Wait a minute..

"I tried this as my final (logical) in-cell code (where rbs_2014 is the column in table 2 with the names I'm trying to match from sheet1... but of course it didn't work:"

rbs_2014 should be a separate table.

lets say, rbs_2014 = coloumn one(first of the sheet) and contains the name you are lookingup
Table 2, contains some data in the first coloumn(second coloumn of the sheet), and
the value you want to return in the second coloumn(third coloumn of the sheet).. yes?

Then you should be able to do this.

=INDEX(Table2,MATCH(D4,rbs_2014,0),2)

Where the number 2, returns the second coloumn of your data table. The match formula only identifies in what row the value of D4 is located. then matching this to table 2. if you are looking up a name, the -1 criteria makes no sense to me :O

although, your data, or a sample is required.

Let me know if it works. :)