var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: variable (as date) in file name for a vlookup function
I have daily excel files with dates as names - for example 07292015_abc.xls. (29th July 2015 file)
How do i write a vlookup function where the date is embedded in the formula?
I want to do the following:
type a date in a particular place and use this date as a variable in the vlookup formula:
=VLOOKUP("inr curncy",'C:\THIS DIR\[07292015_FILE.xls]SHEET (2)'!A:C,3,0)
i type date, in say cell A1, and convert the date to text by =TEXT(A1,"MMDDYYYY"); but am not able to use this in the vlookup function.
By making 07292015 dynamic i would not have to type in the formula for every date.
Thanks for the help.
Tags for this Thread