Use Vlookup between two diferent excel files

[johan.montalvo]

Hi guys. I hope you’re well

I want to use vlookup between two diferents excel files ( ventas.xlsx, expense.xlsx) to extract a column called “gastos_operacion” from the second one towards the first. The pivot column is “Cédula” in both files.

How can i do this?

Do the same but between two woorksheets in the same excel file was too easy, but this is another level.

Thanks a lot.

[Pavan_Kumar177 (Pavan Kumar)]

Hi @johan.montalvo ,

please refer below mentioned link for updating v-lookup,
Link:-https://youtu.be/6TNassqRxw0?si=aiU1NFRfTC0R8arc
Link:-https://youtu.be/CYxrljlILvU?si=QGEu-0CwMscc4PrJ

let me know is this helpful or not!

[johan.montalvo]

Hi @Pavan_Kumar177 ,

For me, your solution is not working… thanks anyways bro!!

[lrtetala (Lakshman Reddy)]

Hi @johan.montalvo

Can you try the following?

"=VLOOKUP(A2,[expense.xlsx]Sheet1!$A:$D,4,0)"

Input Ventas.xlsx:

Input Expense.xlsx:

Output Ventas.xlsx:

BlankProcess18.zip (163.3 KB)

Cheers!!

[johan.montalvo]

Thanks a lot @lrtetala ! Is not the best solution, but it works.
Thank u!!