I HAVE A HLOOKUP FUNCTION THAT IS HAVING A HARD TIME DUE TO THE DATE
CRITERIA.

THE IMPORTED FILE HAS THE DATE AS TEXT SUCH AS (JAN - FEB - MAR, ETC).
BECAUSE OF HOW THE SPREADSHEET IS SETUP THE DATE (lookup_value) IS IN THE
FORM OF 1/1/2005 FORMATED TO MMM-YY.

SO I AM TRYING TO CREATE AN INTERMEDIARY FORMULA THAT CAN EXTRACT JAN OUT OF
JAN 04 (1/1/2004) SO THAT HLOOKUP WORKS. (TEXT JAN TO TEXT JAN)

I HAVE TRIED (BUT NOT TO SAY I AM DOING SOMETHING WRONG);
1. MONTH (A1) = 1, FORMATED TO MMM = NOT RECOGNIZED OR #NA
2. ="" & LEFT(A1,3) = 379, FORMATED TO MMM = 379
3. +LEFT(AO11,3) = 379, FORMATED TO MMM = 379
4. ETC.

ANY HELP IN EXTRACTING "JAN" IN TEXT FORM OUT OF 1/1/2004 WOULD BE TRULY
APPRECIATED.

REGARDS