add data from sheet1 to sheet2 based on matching of serial number and month

[eddi]

i have some data in sheet1 like

SERIAL no Apr'13 May-13 June-13 July-13 August-13
54-003094-1 3.50 3.50 3.50 3.50 3.50
54-003096-1 3.50 3.50 3.50 - -
54-003123-1 3.50 3.50 3.50 - -
54-003171-1 3.50 3.50 3.50 - -
54-003246-1 3.50 3.50 3.50 - -


and some data in sheet2 which contains data as same

SERIAL no May-13 June-13 July-13 August-13
54-003094-1 3.57 3.45 3.57 3.57
54-003096-1 3.57 3.45 3.57 3.57
54-003123-1 3.57 3.45 3.57 3.57
54-003171-1 3.57 3.45 3.57 3.57

i want to add the data from sheet2 to sheet1 where the serial no.and date are matching if the cell contains - or is blank it should add the corresponding data.

attached the excel file
pls help in this issue.

 

[dan_l]

http://chandoo.org/excel-formulas/vlookup.shtml


should help?

 

[eddi]

thanks for the reply the vlookup formula in taking lot of time and need to every time the need to do in new file as the same serialno will have data till a year.
need some vba code so that if new sheet2 is added and run code it will add to sheet1.

 

[dan_l]

No. Just set up the references as relative and you'll be able to expand the formula out to the right indefinitely.

 

[eddi]

could you pls put the formula as i am not able to get the formula as you told. i put the formula for each row manually and copy the data.

i have tried and but not getting attached the excel file can pls check it