Vlookup formula
in [Functions]
|
Prev: assign a macro to send email in lotus notes from Excel spreadsheet
Next: Calc staff vacation time based on more than 1 criteria
From: iv on 6 May 2010 12:43 Hello, I'm using the following Vlookup formula: =IF(ISNA(VLOOKUP(A4,'S:\Operations\Bloomberg\Investment Support\Dummies2Live\2010\May 10\[04052010.xls]Sheet1'!$A$4:$F$600,6,0)),"PRINT",0) This is linked to another spreadsheet - in this case 04052010.xls. Next day I will need to check file 05052010.xls and so on. To make life easier for my colleagues I wanted to add a cell with date where they can input the date and this will change the date in the formula (i.e. from 04052010 to 05052010) How can I link this formula to let's say cell A1 where I want to insert date every day. Thanks Submitted via EggHeadCafe - Software Developer Portal of Choice WPF GridView Sample To Insert, Update, and Delete Records http://www.eggheadcafe.com/tutorials/aspnet/fc9a5bf6-f5bb-4443-a92a-c9a46fd3aeb2/wpf-gridview-sample-to-in.aspx
From: Luke M on 6 May 2010 13:07
The closest thing to this would be to use the INDIRECT function, however... INDIRECT can't be used with an external workbook reference. *sad face* -- Best Regards, Luke M <iv> wrote in message news:20105612436iveta.siryova(a)hotmail.co.uk... > Hello, > > I'm using the following Vlookup formula: > =IF(ISNA(VLOOKUP(A4,'S:\Operations\Bloomberg\Investment > Support\Dummies2Live\2010\May > 10\[04052010.xls]Sheet1'!$A$4:$F$600,6,0)),"PRINT",0) > > This is linked to another spreadsheet - in this case 04052010.xls. Next > day I will need to check file 05052010.xls and so on. To make life easier > for my colleagues I wanted to add a cell with date where they can input > the date and this will change the date in the formula (i.e. from 04052010 > to 05052010) How can I link this formula to let's say cell A1 where I want > to insert date every day. > Thanks > > > Submitted via EggHeadCafe - Software Developer Portal of Choice > WPF GridView Sample To Insert, Update, and Delete Records > http://www.eggheadcafe.com/tutorials/aspnet/fc9a5bf6-f5bb-4443-a92a-c9a46fd3aeb2/wpf-gridview-sample-to-in.aspx |