Find vlookup result of the 1st vlookup

[JTL9161]

I am trying to find the result of a vlookup from a vlookup

I have initials in column B (B1:B100) (JBS)
I have a table (AG1:AH10) Column AG has the same initials as B (JBS)
Column AH has the person's full name John Smith
I now need to vlookup John Smith from another table (AA1:AB10) Column AA has the name John Smith
Column AB has my ending result I am looking for.

So vlookup (b1, AG1:AH10, 2,false) the result of that I need to vlookup in AA1:AB10, 2, false)

Thank you,
James

 

[Fluff]

How about
=vlookup(vlookup (b1, AG1:AH10, 2,false),AA1:AB10,2,0)

 

[JTL9161]

Here is wasn't thinking it was that simple. Thanks. Works perfect.

 

[Fluff]

You're welcome & thanks for the feedback