Breaking down a VLOOKUP formula

[alexbean]

Good afternoon all. Does anyone know what this formula is doing? "Main" is a worksheet. Thanks in advance!

=VLOOKUP(A21,Main!$A:$P,(MATCH($A$1,Main!$11:$11,0))+2,FALSE)

[Jonmo1]

The MATCH is finding the column # A1 appears in row 11 on the Main sheet, then adding 2.
So if the value of A1 is in say E11 on the main sheet, then MATCH returns 5 (E is the 5th column).
Then adds 2, 5+2 = 7

So it goes like this
=VLOOKUP(A21,Main!$A:$P,(MATCH($A$1,Main!$11:$11,0))+2,FALSE)
=VLOOKUP(A21,Main!$A:$P,(5)+2,FALSE)
=VLOOKUP(A21,Main!$A:$P,7,FALSE)

Now it looks for A21 in column A on the Main sheet.
Then returns the corresponding value in the 7th column of the range Main!$A:$P, that would be column G
So if A21 appears in say A52, then it returns the value from G52.

Hope that helps.

[alexbean]

Thank you, that helps a lot!

[Jonmo1]

You're welcome.