VLookup with Variable Data Sheet Source

[rizmomin]

Hello :

I have below formula :

Please Login or Register  to view this content.

where MemPaid is name of the sheet where the data is.

Now I will have the name of the data sheet picked up from Cell P1.
So basically, if P1 is DonationPaid then the above formula needs to be :

Please Login or Register  to view this content.

I hope this is clear.

Please let me know if you have any questions.
Thanks.

RM

[JohnTopley]

Try ..

=VLOOKUP(I8,INDIRECT(P1 &"!" & "$A2:$H$600"),8,0)

[rizmomin]

Hi JohnT:

Thanks a lot...works great
RM