Nestted Vlookup !!!!!!!!

[ETurner00]

Hi,


I have data in column L3 to L26 this is my look up value. My table array is is from A3:I112. The data in the table array is grouped by week day. Coulmn A in the table array shows the days Monday, Tuesday......etc. Column B in the table array is the same data in Column L3. What do I need to do to b able to pull the data in column B, but only for a certain days like Thursday? Also the data in column L repeats on Monday-Sunday.

 

[michaelsmith559]

Can you post a sheet of your data and what results you want?

 

[ETurner00]

cw.gatekeeper@gmail.com

 

[W8253]

Not the best way but:

Insert a helper column e.g. column J where you concatenate the two criteria: =CONCATENATE(A1,B1) so this will be Monday+criteria

Assuming you want to get data from B into column M:

then in cell M1 you put =INDEX(B:B,match(CONCATENATE("Thursday",L1),J:J,false))

Let me know if it works?

 

[W8253]

Not the best way but:

Insert a helper column e.g. column J where you concatenate the two criteria: =CONCATENATE(A1,B1) so this will be Monday+criteria

Assuming you want to get data from B into column M:

then in cell M1 you put =INDEX(B:B,match(CONCATENATE("Thursday",L1),J:J,false))

Let me know if it works?

Should obviously be Thursday.

 

[ETurner00]

Almost. I am trying to pull data from column 9 in the table array A3:I112. When I tried your method I got =INDEX(I:I,MATCH(CONCATENATE("Thursday",L3),$J$3:$J$112,0)). Its pulling the format of the data in column I but its not an exact match, for example L3 should bring back 1 when referecing from the table array, for some reason I get 6 which is not matching anything on thursday, bust some do match so I am not sure what I did wrong. Also I created the helper column in J thats a niffty trick!

 

[ETurner00]

Should obviously be Thursday.

Hey I was able to do it by using concantenate helpers cells and Iferror/vlookup. Thanks for your help. Also I m new to thissite so if there is a way to give credit for helping with the answered questions let me know and I will reward

 

[FDibbins]

Hopefully I got this right (working blond lol) but this should do what you want without the use of a helper...
=INDEX($B$2:$B$100,match("Thursday"&L1,index($A$2:$A$100&$B$3:$B$100,0),0))