Using vlookup to find table from a table

Hi There,

Please can someone help with what vlookup formula i could use to find data from a table?

LEVEL A B C D
9
8 A5 U5
7 A4 U4
6 A3 U3
5 G5 B5 A2 U2
4 G4 B4 A1 U1
3 G3 B3
2 G2 B2
1 G1 B1

Many thanks
Andy

Hello Andy,
not sure I understand exactly what you want to achieve.

Vlookup has 4 arguments :
- The value you're looking up
- The table you're looking the value from
- the index which is the offset
- and finally 'FALSE'

Something worth noticing, is that the function will lookup the value in the first column of your table.

If you give me more context on your problem, I can help you further.

Hi Hemelaire,

Thanks for your reply - I am not sure if VLOOKUP and INDEX will be a correct excel formula to use for this scenario?

LEVEL A B C D
9
8 A5 U5
7 A4 U4
6 A3 U3
5 G5 B5 A2 U2
4 G4 B4 A1 U1
3 G3 B3
2 G2 B2
1 G1 B1

For example, i need to in level 3 and group b = the result should come back as B3

Thanks
Andy

See attached sheet. Use =INDEX($C$2:$F$10,MATCH(A1,B2:B10,0),MATCH(A2,C1:F1,0)) in a3 to look up a1 and a2.

Hi,

Thanks. this works :-)