Hello,
I have several data tables that I would like to reference from and return the row of values for the corresponding variable. I am able to use the Index and Match function for one array table, but I cannot figure out to input multiple arrays in the same function. My ultimate goal is to have several large data tables on one excel sheet as a form of directory. My second sheet will be used to pull certain variables from the directory and return the corresponding values. I started out using the VLOOKUP function, but read several posts explaining how MATCH and INDEX is more appropriate for this situation. I don't know if I am going about solving this issue correctly, but any help will be appreciated.
My formula for C2 is as follows: =(INDEX(C5:C15,MATCH($B$2,$B$5:$B$15,0))). For example, inputting "Date" in cell B2 will return "7" in C2, "4" in D2, "8" in E2, and "4" in F2. I would like to be able and enter say, "Kale" from the second array table to get the correct data, but that is where I am stuck.
This is my first time posting on this forum, so I hope my screen attachment posted correctly and is visible. If not, please let me know so I can try and display my excel sheet example.
Thank in advance for the help.
Screen Shot 2014-10-21 at 10.47.14 PM.png
Bookmarks