That's what I said! But maybe we're not looking at the same post. The
range in the second VLOOKUP is "AZ:BA", which is only 2 columns. Though
"BA" is the 57th column, it seems as though the second column of the range
("AZ:BA") is what was desired. That's why I said "I think you probably want
2". Maybe I'm wrong though.


"T. Valko" wrote in message
...
The only problem with that is there aren't 57 columns in the range
'2007'!$B:$AC.

Biff

"PCLIVE" wrote in message
...
In your second VLOOKUP, your range(array) is AZ:BA which is 2 columns.
Then your column index is 57. I think you probably want 2.
=VLOOKUP(CONCATENATE($A14,C$13),'2007'!$B:$AC,(VLO OKUP(E2,AZ:BA,2,0)),FALSE)

"Ryan" wrote in message
oups.com...
I have a spreadsheet that I use VLookup to find a Person's scores
based on Month. However, I have to change the reference number in the
VLookup manually in order to get my results.

I use column number 28 for April, column number 57 for May. I was
using a very basic formula that got me by using IF/Vlookup for April
alone, but now that it's May, I had to change the column number
manually.

I tried this formula, but it seems that you can't nest a Vlookup
inside a Vlookup! :)

=VLOOKUP(CONCATENATE($A14,C$13),'2007'!$B:$AC,(VLO OKUP(E2,AZ:BA,
57,FALSE)),FALSE)

Help would be greatly appreciated!! :) Thanks for your time & efforts.