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
Related:
- Matching values in two spreadsheets
- Excel match two columns and output third ✓ - 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. - Software Forum
- Based on the values in cells b77 b81 ✓ - Excel Forum
- Matching Names to Id Numbers - Excel Forum
- I can't enter in my account - Windows 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.
