jonnyjonjon
10-03-2017, 01:51 AM
Hello,
I'm very new to VBA programming and I am required to complete a certain task in my current work project with VBA. I've tried to program it myself but it does not seem to work. In short, I'm required to perform a VLOOKUP function on another excel file.
There are two files, called "FileX" and "FileY". FileX is the main file and FileY is where the data will be taken from.
The VLOOKUP function will only be done if the value in column N for that particular row is either "Approved" or "Quoted".
For the VLOOKUP function, it will be placed on column BH and the values are,
Lookup valve = A2 of FileX
Range containing lookup value = Columns R:BK of FileY
Column number = 21
False
Also, is it able for the marco to perform this for every single row, until an empty row is detected?
Would appreciate any help, and thank you so much in advance.
I'm very new to VBA programming and I am required to complete a certain task in my current work project with VBA. I've tried to program it myself but it does not seem to work. In short, I'm required to perform a VLOOKUP function on another excel file.
There are two files, called "FileX" and "FileY". FileX is the main file and FileY is where the data will be taken from.
The VLOOKUP function will only be done if the value in column N for that particular row is either "Approved" or "Quoted".
For the VLOOKUP function, it will be placed on column BH and the values are,
Lookup valve = A2 of FileX
Range containing lookup value = Columns R:BK of FileY
Column number = 21
False
Also, is it able for the marco to perform this for every single row, until an empty row is detected?
Would appreciate any help, and thank you so much in advance.