Compare Column A to Column B and return Column C
Solved/Closed
ad1959
ad1959
- Posts
- 10
- Registration date
- Thursday March 6, 2014
- Status
- Member
- Last seen
- August 18, 2020
ad1959
- Posts
- 10
- Registration date
- Thursday March 6, 2014
- Status
- Member
- Last seen
- August 18, 2020
Related:
- Compare Column A to Column B and return Column C
- Comparing columns and returning value ✓ - Forum - Excel
- Comparing columns and returning value ✓ - Forum - Excel
- Excel - Compare column A & B give results in column C - How-To - Excel
- Compare columns and create list of duplicates ✓ - Forum - Excel
- Comparing columns in Excel 2010 ✓ - Forum - Excel
2 replies
Mazzaropi
Mar 6, 2014 at 04:17 AM
- Posts
- 1963
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- April 25, 2022
Mar 6, 2014 at 04:17 AM
ad1959, Good morning.
Try to use it:
D2 --> =VLOOKUP(C2,$A$2:$B$8,2,FALSE)
Copy down this formula.
Adjust the range to your reality.
Please, tell us if it worked for you.
I hope it helps.
Belo Horizonte, Brasil.
Marcílio Lobão
Try to use it:
D2 --> =VLOOKUP(C2,$A$2:$B$8,2,FALSE)
Copy down this formula.
Adjust the range to your reality.
Please, tell us if it worked for you.
I hope it helps.
Belo Horizonte, Brasil.
Marcílio Lobão
ad1959
Mar 6, 2014 at 07:25 PM
- Posts
- 10
- Registration date
- Thursday March 6, 2014
- Status
- Member
- Last seen
- August 18, 2020
Mar 6, 2014 at 07:25 PM
Thanks Mazzaropi soved it perfectly. I was on the right track but you saved me a lot of time.