Printable View
Hello
I have 2 spreadsheets.
Spreadsheet 1, Column "D" lists my unique job numbers. If the job number is found in Spreadsheet 2, column "G", then i need to copy the contents of Column "L" from Spreadsheet 1 over to the corresponding/matched Job number in Sheet 2 and paste the contents from Column "L" Sheet1, into Column "CI" in SHeet 2.
I'm lost....please help!!
thanks
you can achieve it with or without code. how do you want to achieve it?
I don't mind. I need to do this on a weekly basis so whatever you think is best - easiest method possible....without code probably would be easier for me!
It's quite simple with VLOOKUP() formula on sheet, no need VBA code.
If I understand you correctly:
In cell "CI2" of Sheet2, enter: =VLOOKUP($G2, Sheet1!$D:$L, 9, 0)
(replace Sheet1 with your actual sheet name)
then copy cell CI2 downward.
If a job number in column G of Sheet2 not found, #N/A will displays.
amazing!!!
Exactly what i needed....works brilliant
Thank you very much for your time.
what does the 9,0 at the end of your formula mean?
=VLOOKUP($G2, Sheet1!$D:$L, 9, 0)
9 : counting number of columns from D to LQuote:
Originally Posted by gilly
0 (or FALSE) : Exactly match
Search Help for VLOOKUP function to learn more.
If you are happy with the solution please mark your thread as resolved.
I tend to use an Index Match combination, will give you the same results as above
But thought it worth posting anyway
=INDEX(Sheet2!$D:$L,MATCH($A1,Sheet2!$A:$A,0),2)
0 in this formula again means exact match
and 2 returns the 2nd column. i.e. column E