bloodmilksky
Board Regular
- Joined
- Feb 3, 2016
- Messages
- 202
[TABLE="width: 1236"]
<tbody>[TR]
[TD]Hi Guys,
I need some help with the below. I need to be able to add if date returned is more than "1/1/1970 12:00:00 AM" to show that date and to also not change the value to "Made To Order" if there is a recent date in table that I am drawing the values from.
I also would like some advice, if i am going to be using this often how could I transfer this to VBA please
IF(OR(ISNUMBER(SEARCH("LCLARCX387",H2)),ISNUMBER(SEARCH("LFQXLXR387",H2)),ISNUMBER(SEARCH("LPCCTXR388",H2))),"Made to order",VLOOKUP(H2,'VE Orders Not Delivered (Not Ba'!E1:F25,2,FALSE))
Many thanks
Jamie
[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
<tbody>[TR]
[TD]Hi Guys,
I need some help with the below. I need to be able to add if date returned is more than "1/1/1970 12:00:00 AM" to show that date and to also not change the value to "Made To Order" if there is a recent date in table that I am drawing the values from.
I also would like some advice, if i am going to be using this often how could I transfer this to VBA please
IF(OR(ISNUMBER(SEARCH("LCLARCX387",H2)),ISNUMBER(SEARCH("LFQXLXR387",H2)),ISNUMBER(SEARCH("LPCCTXR388",H2))),"Made to order",VLOOKUP(H2,'VE Orders Not Delivered (Not Ba'!E1:F25,2,FALSE))
Many thanks
Jamie
[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
