Matching values in two spreadsheets
Closed
Bkkppr
Posts
1
Registration date
Thursday November 25, 2010
Status
Member
Last seen
November 25, 2010
-
Nov 25, 2010 at 07:03 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 26, 2010 at 04:30 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 26, 2010 at 04:30 AM
Hello,
I have an Excel sheet that has all of my project Estimate values in it (column 2). Column 1 has the names of the service provided. I then have my next sheet with an import from Accounting that shows the names of services and the actuals. I would like to match the names in both sheets and if True and then import the new actuals into sheet 1. Can you help me?
Thanks
Bkkppr
I have an Excel sheet that has all of my project Estimate values in it (column 2). Column 1 has the names of the service provided. I then have my next sheet with an import from Accounting that shows the names of services and the actuals. I would like to match the names in both sheets and if True and then import the new actuals into sheet 1. Can you help me?
Thanks
Bkkppr
Related:
- Matching values in two spreadsheets
- We couldn't find an account matching the login info you entered ✓ - Facebook Forum
- Based on the values in cells b77 b81 c77 - Excel Forum
- We couldn't find an account matching the login info you entered, but found an account that closely matches based on your login history. - Excel Forum
- Facebook account not match - Laptop Forum
- We couldn't find an account matching the login info you entered, but found an account that closely matches based on your login history - Facebook Forum
2 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Nov 26, 2010 at 04:28 AM
Nov 26, 2010 at 04:28 AM
sheet1 has this data A1 down
service estimate
a 1
s 2
d 3
f 4
sheet 2 has data from accounting team
service actuals
a 4
s 5
d 6
f 7
in sheet1 in C2 copy this formula
=VLOOKUP(A2,Sheet2!$A$1:$B$30,2,0)
copy c2 down
I assumed there are data upto row no. r0. if more modify the formula.
service estimate
a 1
s 2
d 3
f 4
sheet 2 has data from accounting team
service actuals
a 4
s 5
d 6
f 7
in sheet1 in C2 copy this formula
=VLOOKUP(A2,Sheet2!$A$1:$B$30,2,0)
copy c2 down
I assumed there are data upto row no. r0. if more modify the formula.
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Nov 26, 2010 at 04:30 AM
Nov 26, 2010 at 04:30 AM
the last sentence in the message should read
I assumed there are data upto row no. 30. if more modify the formula.
I assumed there are data upto row no. 30. if more modify the formula.