Microsoft Excel - Macro + copy cell + find Cell + copy coressponding value & paste back
Asked By Blue J
10-Feb-12 07:20 AM
Hi all,
I need a macro which will copy the first cell of column A, sheet2 and find the same in sheet 1.
After finding, it should find the last cell with the same value &
copy the corresponding cell from column H, sheet 1 and paste it back to
col D in sheet 2
this process should be carried out for all the cells in column A, sheet 2
Please please please help me out.
Thanks
Blue J
Donald Ross replied to Blue J
Blue J,
Here is a formula you can use.
The Vlookup function will look at the range and return the last match by default.
on sheet 2 colum D
=VLOOKUP(A1,Sheet1!A:H,8)
see attached zip file.
Blue J Lookup.zip
HTH
DON
Vlookup Excel Looking for someone who knows vlookup. Excel Discussions Microsoft Excel (1) VLOOKUP (1) SalesAid (1) Dguillett1 (1) http: / / www.contextures.on.ca / xlFunctions02.html Gord Dibben MS Excel MVP Can you be a little more specific on what you want to do with
Vlookup Excel Is it possible to have a sum in a Vlookup? Excel Worksheet Discussions Microsoft Excel (1) MEubT1IWP8 (1) VLOOKUP (1) FLOOR (1) SUMIF (1) INT (1) MID (1) SUM (1) See if this is 2 Sum column B where column A = x: = SUMIF(A1:A5, "x", B1:B5) - - Biff Microsoft Excel MVP Can I send you a sample of the file and show you what
Combining Average, Offset & Vlookup Excel Excel 2002 Hi Excel users and Experts, I'm trying to lookup a value in a list, and average is a cell in the list column and I want to replace F9 with a vlookup or a lookup or a match where the lookup or match reference is supplied by need. AVERAGE(OFFSET(lookup(B2, F2:G16, 1, 0), 0, 1, -4, 1)) AVERAGE(OFFSET(vlookup(B2, F2:G16, 1, 0), 0, 1, -4, 1)) AVERAGE(OFFSET(indirect(lookup(B2, F2:G16, 1, 0), 0, 1, -4, 1))) Thanks, Regards, Howard Excel Worksheet Discussions VNWdnRQrZcAMMKfanZ2dnUVZ (1) F42dnaIAlue1FqfanZ2dnUVZ (1 Microsoft Excel (1) Excel (1) ISERROR (1) AVERAGE (1) OFFSET (1) INDEX (1) Try it like
Microsoft Excel, VLookup, Drop Downs, and Validation. This should be so simple- yet I can't find it found formulas, but nothing that addresses the content being on a separate sheet. . . HELP PLEASE!!!! Microsoft Excel (1) VLookup (1) Drop Downs (1) Validation (1) You should be able to use the VLookup: = VLookup(A2, EmployeeRates!A2:B200, 2, false) Where A2 has the employee number, and your employee
Copying Sheet2 data To Sheet1 Thru VLOOKUP Excel Pleae Help Excel Discussions Microsoft Excel (1) VLOOKUP (1) Pleae (1) Bliengme (1) Caps (1) There is lots of room in the white space (here) to give us a bit more detail - -please! best wishes - - Bernard V Liengme Microsoft Excel MVP http: / / people.stfx.ca / bliengme remove caps from email First, heed Bernard's advice