I have a cell format search criteria over a specified column range. When the
criteria is satified, I need to enter a formula using VLOOKUP in an adjacent
column that uses the value in the cell that satisfied my format search
criteria as the lookup value.

I used the formaul:
"=VLOOKUP(Target,'C:\Documents and
Settings[SummaryByProject(111005).xls]Current'!$B$1:$D$585,2,FALSE)"
, where I tried to define Target as the cell that satisfied teh search
criteria, but it does not work.

I'd apprecaite any help you can give on this
Thanks
--
Los