CCkfm2000
05-28-2007, 09:20 AM
hi all...
i've got the following vlookup, what i'm trying to do is to be able to change the number 29.05 from within a cell i.e A1
this vlookup will look at a different file.
I can change the formula manually.
=vLOOKUP(A4,'[ICE_TRAF 29.05.xls]ICE_TRAF'!$A:$R,4,FALSE)
thanks
i've got the following vlookup, what i'm trying to do is to be able to change the number 29.05 from within a cell i.e A1
this vlookup will look at a different file.
I can change the formula manually.
=vLOOKUP(A4,'[ICE_TRAF 29.05.xls]ICE_TRAF'!$A:$R,4,FALSE)
thanks