Need help on excell

[ajay]

Hi Guys,

can you please help me with some excel formulas.

My requirement is below:

i have one excel file with two sheets.

Sheet 1 contains some numbers in Row A.

Sheet 2 also contains some numbers in Row A and some text and value in Row B.

I need one formula if value of Row of Sheet 1 match with the Row A of sheet 2, it copy the value of Row of B of Sheet 2 and past into sheet 1 next to Row A.

Thanks,
Ajay

 

[Luke M]

On Sheet1, cell B2:
=SUMIF('Sheet 2'!B:B,A2,'Sheet 2'!A:A)

If your sheet names are not exact match, you'll need to adjust to suit.

 

[bobhc]

ajay

The reason people visit the forum is because "Need help on excell" or excel, you would get more help if you gave a better description in the title