Hello,

I am trying to modify the following formula:

=VLOOKUP(10,'W:\CARS Accounting\CARS Recs\Prod, Susp, Ext, Misc\2008 Product
Reports\08-Aug\[08-23-08 PRODRPT.XLS]CFPRODRPT082608'!$D$3:$F$19,3)

The part I would like to change is the $3 and $19 part of the formula. I
would like these pieces to reference cells within the spreadsheet. IE:
$D(P5):$F(Q5).

I have tried things like $D"P5" and $D"& P5 &" to no avail. Any help would
be greatly appreciated.

--
David Stampor