Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup errors #n/a | Excel Worksheet Functions | |||
Cell Formats & other errors | Excel Discussion (Misc queries) | |||
VLOOKUP AND N/A ERRORS | Excel Discussion (Misc queries) | |||
vlookup with date formats | Excel Worksheet Functions | |||
VLookup Errors | Excel Worksheet Functions |