How to column match Two Different Excel Sheets

[Shiva_Kumar1 (Shiva Kumar)]

I have Two Different Excel Sheets I want Read “GST” Numbers first Excel And Also Second Excel Sheet “GST Code” We Have To Match And Also Get "Bus Place " Numbers Enter Into That numbers in to The web

|GST || Primary Excel Sheet
| |
|37AAACH2778K1Z8||
|36AAOFV108281Z8||

|State |GST Code|Bus Place|

|TELANGANA |36 |1000|
|ANDHRA PRADESH |37 |1001|

[sai_krishna_somisetty (sai krishna)]

Hi @Shiva_Kumar1

Extract the GST code from GST number like

“37AAACH2778K1Z8”.substring(0,2) gives result 37

for each row in dt2
if gstcode = 37 get BusPlace

thanks

[Shiva_Kumar1 (Shiva Kumar)]

hai @sai_krishna_somisetty I have Multiple Rows In That GST Numbers And GST Codes Then How Should I do

[sai_krishna_somisetty (sai krishna)]

Hi @Shiva_Kumar1

go through this work flow

Dictionary and search.xaml (13.2 KB)

what i’ve done is from second sheet, I’ve taken gst code and bus place as (key, value) pair. so loop the first sheet, extract the GST code from GST number and get the bus number from dictionary using gst code as KEY.