Spreadsheet comparisons and data population

[melina]

Hi, my name is Melina


Please may I ask for assistance with the following:


1. Compare items in Column C of spreadsheet A to Column C of spreadsheet B.

2. Find same item numbers (note these are not in consecutive order).

3. Once the item is found, then go to cell J of the line item on spreadsheet A and copy the details and paste this detail in cell L of spreadsheet 2 of the corresponding line item.


Please may I ask if it is possible to do such a transaction.

Which options would be used, e.g. Vlookup?


Thank you very much for your assistance.

Melina

 

[Faseeh]

Hi melina!!


Welcome to the forum, it will be lot easier if you upload a sample file, just upload it to some file sharing site and drop its link here!!


Faseeh

 

[nazmul_muneer]

Dear Melina,


Do you want to find out unique values in the column-C comparing the both two sheets? or the extra values in sheet-A?

Please make clear


Regards,


--Muneer

 

[melina]

Hi


Thank you so much for your response.


The file can be downloaded at the following location:


http://www.2shared.com/file/cyxkKyUi/SAMPLE_WB.html

 

[sdsurzh]

Hi Melina,


Can you please download the below file and check whether you looking for this kind for solution


http://www.2shared.com/file/iuSXPn4z/SAMPLE_WB_1_.html


Thanks,

Suresh Kumar S

 

[melina]

Hi Suresh


Thank you very much.


The idea is to find the same numbers between the spreadsheets Sheet 1 (column C) and Sheet 2 (Column C).


E.g.


If Cell C1 = 1234567 in sheet 1, then look for 1234567 is Column C of sheet 2, which could be on Cell 3 of column C in sheet 2.


When this identification is done, then copy the value from Cell J1 (correspondin to C1) of sheet 1 and paste into Cell L3 corresponding with C3 of sheet 2.


I am really sorry for the confusing message.


Thank you for your help.

It is greatly appreciated.

Melina

 

[NARAYANK991]

Hi Melina ,


Use the VLOOKUP function , whose syntax is :


=VLOOKUP(value to be looked up,Data Table,Column to be copied,FALSE)


In your case , in cell L4 on Sheet2 , you would use the following formula :


=VLOOKUP(C4,Sheet1!$C$2:$J$4,8,FALSE)


Copy this downwards.


If you don't want the error values #N/A to appear when the value to be matched is not found in the data table , use an IFERROR wrapper , as follows :


=IFERROR(VLOOKUP(C4,Sheet1!$C$2:$J$4,8,FALSE),"")


Narayan

 

[melina]

Hi


Thank you so much.


Melina