How to vlookup value between 2 excel files?

[yangyq10 (IvanY)]

Dear Friends

I have 2 excel files [JACCS] & [SAPdownload]

I need to vlookup Net value from [SAPdownload] to SAP Net value in [JACCS]

The key value between this 2 files are VL & SO#

And I need to use the activities under excel to do it

May I have some guidance from you? I am quite confused after several attempts

Thank you for your kind help in advance

Ivan

[JACCS]

[SAPdownload]

[Jayesh_678 (Jayesh)]

Hi,

Use below excel formula:-

=VLOOKUP(B2, [SAPdownload.xlsx]Sheet1!$A$2:$B$100, 2, FALSE)

Parameters:-

• B2: This is the cell containing the key (SO#) in [JACCS]. You might need to adjust this based on the location of your data.
• [SAPdownload.xlsx]: Replace this with the name of your [SAPdownload] file.
• Sheet1: Replace this with the name of the sheet in [SAPdownload] where your data is located.
• $A$2:$B$100: This is the range in [SAPdownload] where your data is located. Adjust the range to match your data.
• 2: This specifies that you want to retrieve the value from the second column of your data range (Net value).
• FALSE: This specifies an exact match lookup.

Once you’ve entered the formula, drag it down to apply it to all relevant cells in the [JACCS] file.

Thanks

[yangyq10 (IvanY)]

Thank you Jayesh
It works in simple way!