VLOOKUP Errors with Date formats
 

I need some help with a VLOOPUP function. I have a TAB1 with 10000 rows,
Column A has 10000 unique numbers. Each unique ID is linked to a Dispatch #.
In TAB 2 I have a list of 233 unique Dispatch #s and a date in column B when
the Dispatch was created. I need to create a VLOOKUP in Column C update the
date corresponding to when the Dispatch was created.

=IF(ISERROR(VLOOKUP(B2,Invlog!$A$2:$B$233,17,FALSE )),"",VLOOKUP(J2,Invlog!$A$2:$B$233,17,FALSE))

For dispatches that do not have a date in column B I get 1/0/00 in Tab1. I
need to know how to display a Blank cell. I use excel 2003.

A B C D E

Unique ID1 Dispatch 1 Date 1
Unique ID2 Dispatch 2 1/0/00
Unique ID3 Dispatch 1 Date 1
Unique ID4 Dispatch 3 Date 3
Unique ID5 Dispatch 1 Date 1
Unique ID6 Dispatch 2 1/0/00
Unique ID7 Dispatch 3 Date 3



A B C

Dispatch 1 Date 1
Dispatch 2
Dispatch 3 Date 3
Dispatch 4 Date 4
Dispatch 5 Date 5
Dispatch 6
Dispatch 7 Date 7

VLOOKUP Errors with Date formats
 

Sam,

Maybe:

=IF(ISBLANK(VLOOKUP(B2,Invlog!$A$2:$B$233,17,FALSE )),"",VLOOKUP(J2,Invlog!$A$2:$B$233,17,FALSE))

or

=IF(VLOOKUP(B2,Invlog!$A$2:$B$233,17,FALSE)=0,"",V LOOKUP(J2,Invlog!$A$2:$B$233,17,FALSE))

HTH,

Conan Kelly







"Sam" wrote in message
...
I need some help with a VLOOPUP function. I have a TAB1 with 10000 rows,
Column A has 10000 unique numbers. Each unique ID is linked to a Dispatch
#.
In TAB 2 I have a list of 233 unique Dispatch #s and a date in column B
when
the Dispatch was created. I need to create a VLOOKUP in Column C update
the
date corresponding to when the Dispatch was created.

=IF(ISERROR(VLOOKUP(B2,Invlog!$A$2:$B$233,17,FALSE )),"",VLOOKUP(J2,Invlog!$A$2:$B$233,17,FALSE))

For dispatches that do not have a date in column B I get 1/0/00 in Tab1. I
need to know how to display a Blank cell. I use excel 2003.

A B C D E

Unique ID1 Dispatch 1 Date 1
Unique ID2 Dispatch 2 1/0/00
Unique ID3 Dispatch 1 Date 1
Unique ID4 Dispatch 3 Date 3
Unique ID5 Dispatch 1 Date 1
Unique ID6 Dispatch 2 1/0/00
Unique ID7 Dispatch 3 Date 3



A B C

Dispatch 1 Date 1
Dispatch 2
Dispatch 3 Date 3
Dispatch 4 Date 4
Dispatch 5 Date 5
Dispatch 6
Dispatch 7 Date 7