PDA

View Full Version : Code needed: Find or Vlookup



YellowLabPro
10-22-2008, 07:36 AM
It has been quite a long time for my code writing, about a year. I need a huge favor, if someone could write this code for me please?

I have values in the source sheet that I need placed in the target sheet. The target sheet will use the index value to make the reference to the target sheet, e.g. a vlookup or a find.

I am currently using a worksheet formula of:

=VLOOKUP(A4,[MasterImportSheetWebStore.xls]Discounts!$A$4:$J$7209,9)


Workbook "MasterImportSheetWebStore.xls" Worksheet "Discounts" is the source of the data, range "A4:lastrow" for the index value and corresponding "J4:lastrow" for the data that is to be copied to the target sheet and range.

Workbook "Complete_Upload_File_Green.xls" Worksheet "EC Products" is the target worksheet, range hosts both sheets. Target Sheet "EC Products", Source Sheet "Discounts" range "A4:lastrow" for the index value and "F4:lastrow" for the source data to be copied.

Hope I have provided all the details, and thanks for the help.

Regards,

Doug