Formula for: If data on column A on Sheet 1 matches data on column A on Sheet 2, copy value from column B in Sheet 2 into Column B in Sheet 1

[Charles_]

Hello,

I need help with a formula please, I have data on 2 different spreadsheets. As per the title, I need a formula that will help me do: If data on column A (ID) on Sheet 1 matches data on column A on Sheet 2 (ID), copy value from column C ($) in Sheet 2 into Column B in Sheet 1 ($) .

Thanks!

Example

Sheet 1 (I need to populate Column C $ with the value on Sheet 2 where theres an ID match sheet 2)

ID	Name	$
1	Joe	1
2	Sue
3	Mark

Sheet 2

ID	Name	$
1	Joe	10
4	Peter	5
9	JP	4
2	Sue	30
6	Ray	25
3	Mark	5

 

[hrayani]

Hi Charles,
I am not sure if this is what you want

in B2 Sheet 1

=INDEX(Sheet2!B$2:B$7,MATCH(Sheet1!$A2,Sheet2!$A$2:$A$7,0))

in C2 Sheet 1

=INDEX(Sheet2!C$2:C$7,MATCH(Sheet1!$A2,Sheet2!$A$2:$A$7,0))

 

[Fluff]

Another option, if the IDs on sheet2 are unique

=sumifs(Sheet2!C:C,Sheet2!A:A,A2)