[TABLE="class: grid, width: 250"]
<tbody>[TR]
[TD]Order No
[/TD]
[TD]Order Status
[/TD]
[/TR]
[TR]
[TD]1234
[/TD]
[TD]Shipped 2/20/19
[/TD]
[/TR]
[TR]
[TD]1235
[/TD]
[TD]Shipped 1/5/19
[/TD]
[/TR]
[TR]
[TD]1236
[/TD]
[TD]Prepped for Shipment
[/TD]
[/TR]
[TR]
[TD]1237
[/TD]
[TD]Shipped 3/1/19
[/TD]
[/TR]
[TR]
[TD]1238
[/TD]
[TD]Shipped 3/10/19
[/TD]
[/TR]
[TR]
[TD]1239
[/TD]
[TD]Shipment Confirmed
[/TD]
[/TR]
[TR]
[TD]1240
[/TD]
[TD]Shipped 2/15/19
[/TD]
[/TR]
[TR]
[TD]1241
[/TD]
[TD]Prepped for Shipment
[/TD]
[/TR]
[TR]
[TD]1242
[/TD]
[TD]Shipment Confirmed
[/TD]
[/TR]
</tbody>[/TABLE]
I would like to do a vlookup for the following:
The lookup the criteria in column A
The range is in column B
If the text in column B is "Shipped" with a date then the result should be X
If the text in column B is "Shipment Confirmed" then the result should be "Shipment Confirmed"
If the text in column B is "Prepped for Shipment" then the result should be "Prepped for Shipment"
If the result doesn't meet any of the criteria above then blank.
So for Order No 1239 and 1242 I would like the result to be "Shipment Confirmed" and for Order No 1241 and 1236 the result would be "Prepped for Shipment". For anything that says "Shipped" with a date should be X. If there is any other text not listed above or a blank in the Order Status the result should be blank.
Thank you all for your time and I look forward to the results.
<tbody>[TR]
[TD]Order No
[/TD]
[TD]Order Status
[/TD]
[/TR]
[TR]
[TD]1234
[/TD]
[TD]Shipped 2/20/19
[/TD]
[/TR]
[TR]
[TD]1235
[/TD]
[TD]Shipped 1/5/19
[/TD]
[/TR]
[TR]
[TD]1236
[/TD]
[TD]Prepped for Shipment
[/TD]
[/TR]
[TR]
[TD]1237
[/TD]
[TD]Shipped 3/1/19
[/TD]
[/TR]
[TR]
[TD]1238
[/TD]
[TD]Shipped 3/10/19
[/TD]
[/TR]
[TR]
[TD]1239
[/TD]
[TD]Shipment Confirmed
[/TD]
[/TR]
[TR]
[TD]1240
[/TD]
[TD]Shipped 2/15/19
[/TD]
[/TR]
[TR]
[TD]1241
[/TD]
[TD]Prepped for Shipment
[/TD]
[/TR]
[TR]
[TD]1242
[/TD]
[TD]Shipment Confirmed
[/TD]
[/TR]
</tbody>[/TABLE]
I would like to do a vlookup for the following:
The lookup the criteria in column A
The range is in column B
If the text in column B is "Shipped" with a date then the result should be X
If the text in column B is "Shipment Confirmed" then the result should be "Shipment Confirmed"
If the text in column B is "Prepped for Shipment" then the result should be "Prepped for Shipment"
If the result doesn't meet any of the criteria above then blank.
So for Order No 1239 and 1242 I would like the result to be "Shipment Confirmed" and for Order No 1241 and 1236 the result would be "Prepped for Shipment". For anything that says "Shipped" with a date should be X. If there is any other text not listed above or a blank in the Order Status the result should be blank.
Thank you all for your time and I look forward to the results.