Matching values in two spreadsheets
Closed
Bkkppr
Posts
1
Registration date
Thursday 25 November 2010
Status
Member
Last seen
25 November 2010
-
25 Nov 2010 à 19:03
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 26 Nov 2010 à 04:30
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 26 Nov 2010 à 04:30
Related:
- Matching values in two spreadsheets
- Google spreadsheets download - Download - Spreadsheets
- Sed delete matching line - Guide
- 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
- Based on the values in cells b77 - Excel Forum
- How to match two spreadsheets in excel - Guide
2 responses
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
26 Nov 2010 à 04:28
26 Nov 2010 à 04:28
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 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
26 Nov 2010 à 04:30
26 Nov 2010 à 04:30
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.
