Thanks for both of the responses...very helpful

"Mike H" wrote:

Try this

=VLOOKUP($A$4,INDIRECT("'P"&ROW(A35)&"'!$A$2:$H$83 "),7,FALSE)

Mike

"Confusicous" wrote:

I have a Vlookup formula that I want to copy over but everytime I do it
changes...Example: Original formula =VLOOKUP(A4,'P35'!$A$2:$H$83,7,FALSE)
when I copy and paste right next to it I get
=VLOOKUP(B4,'P35'!$A$2:$H$83,7,FALSE)...Actually what I need is the B4 to
remain A4 and if its possible to get the 'P35' to go to 'P36'...I am open to
any thoughts or ideas. Thanks in advance