[RESOLVED] Excel Match

[gilly]

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

[Siddharth Rout]

you can achieve it with or without code. how do you want to achieve it?

[gilly]

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!

[anhn]

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.

[gilly]

amazing!!!

Exactly what i needed....works brilliant

Thank you very much for your time.

[gilly]

what does the 9,0 at the end of your formula mean?

[anhn]

=VLOOKUP($G2, Sheet1!$D:$L, 9, 0)

what does the 9,0 at the end of your formula mean?

9 : counting number of columns from D to L
0 (or FALSE) : Exactly match

Search Help for VLOOKUP function to learn more.

[anhn]

If you are happy with the solution please mark your thread as resolved.

[Mitch_s_s]

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