Hi, I have a table which contains DAY+MONTHeg;01-Marin cellA2andYEARin cellB1. I want to look upA2andB1in order to get data from a table array which contains full date eg; 01-02-2011. When I try vlookup formula, all i get is #NA. Please I need help urgently. Thanks in advance

✔ Best Answer

I'm assuming your trying to do this with Microsoft Access? What is your VB code you have so far?

How is 01-Marbeing recorded? As TEXT or as a DATE?When you place the cursor on the cell that contains 01-Mar, what does

theformula barup top show?MIKE

I am working in excel. 01-Mar is recorded as text.

this is the vlookup formula i have so far =VLOOKUP(A2&B1,G3:J68,4,0)

01-Mar is recorded as text

OK, try this: If your data looks like this:

A B 1) 01-Mar 2009 2) 02-Mar 2010In C1 enter the formula:

=DATEVALUE(A1&B1)

MIKE

Thanks Mike. It's working now. You've saved me a lot. Am most grateful....Cheers

Ask Your Question

Weekly Poll

Do you think its a good idea for Amazon to divide its new second headquarters between two locations?

Discuss in The Lounge

Poll History