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)
Sheet 2
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 |