check for additional spaces or if format is the same ( if you are lookingi
foir numbers )
mcg
U¿ytkownik "Los in RI" napisa³ w
wiadomo¶ci ...
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