How to use dynamically vlookup for two different excel file

Feedback Studio
, , , , ,
1

Hello everyone,

I have two excel file and i have to use vlookup

IMG20240505142043
IMG202405051420431920×1440 558 KB

Above image is first excel file in the column grn status using vlookup as shown in image

IMG_20240505_152426
IMG_20240505_1524261920×2573 897 KB

In second image i have to select 11 column ( Po no to Grn )

I can do by using write cell but if the any extra column add in between those columns then bot will failed so i have to select column PO No to GRN the. Any column will add it wont be affect.

Thanks

3

@suraj_gaikwad

Then first read the second excel and check where your required columns are there using indexof method

Then you can use the respective columns in the pivot

Cheers