ORDER ID | NAME | TIME | LOCATION | CODE |
OR4819ZF-001A | Om Chaudhary | 03-11-2017 20:04 | Gandhinagar | 382028 |
OR6296YF-001A | Shantaben R patel | 03-11-2017 20:05 | Patan | 384265 |
OR7051YF-001A | RAJENDRA PATEL | 03-11-2017 20:05 | Anand | 388121 |
OR7493XF-001A | S K AZAD | 03-11-2017 13:19 | Warangal | 506001 |
OR1932YF-001A | Rajesh Goyal | 03-11-2017 21:07 | Shivpuri | 473551 |
OR3368ZF-001A | DHANALAXMI | 03-11-2017 13:19 | Warangal | 506002 |
OR6800XF-001A | G LAXMI PRIYA | 03-11-2017 13:19 | Warangal | 506002 |
OR5834YF-004A | RENUKA SINGH | 03-11-2017 21:07 | Katni | 483501 |
OR5834YF-003A | RENUKA SINGH | 03-11-2017 21:07 | Katni | 483501 |
OR7926V-001A | AutoGqXiSO AutowUyCme | 02-11-2017 14:51 | Bangalore | 560100 |
OR8004V-001A | AutogxHkUt AutozQeLVH | 02-11-2017 15:01 | Bangalore | 560100 |
OR8237V-001A | AutoFmeVUf AutoWZzvKz | 02-11-2017 19:41 | Bangalore | 560100 |
OR6422YF-001A | GANGABEN | 03-11-2017 20:05 | Bhavnagar | 364001 |
OR3439YF-001A | Natubhai | 03-11-2017 20:05 | Jamnagar | 361006 |
<colgroup><col><col><col><col span="2"></colgroup><tbody>
</tbody>
Dear people
this is small example from my huge excel sheet
can i get the code directly when i enter order id in different work book i have shared a result in which i expecting result in such way
WHEN I PUT THIS ORDER ID I SHOULD GET CODE DIRECTLY ALL TOGATHER | |
ORDER ID | CODE |
OR6296YF-001A | 384265 |
OR7051YF-001A | 388121 |
OR7493XF-001A | 506001 |
OR7926V-001A | 560100 |
OR8004V-001A | 560100 |
OR8237V-001A | 560100 |
OR6422YF-001A | 364001 |
<colgroup><col><col></colgroup><tbody>
</tbody>