Dear All,
I have a cell where is "Unit Price 19/05/2011". By formulas I extract date from that cell and using vlookup I'm serching for unit price corresponding to that day. However, the extracted date I guess is in text format and vlookup doesn't recognize it when it's searching for it. How can I make it?
Thanks
I have a cell where is "Unit Price 19/05/2011". By formulas I extract date from that cell and using vlookup I'm serching for unit price corresponding to that day. However, the extracted date I guess is in text format and vlookup doesn't recognize it when it's searching for it. How can I make it?
Thanks