Compare Column A to Column B and return Column C
Solved/Closed
ad1959
Posts
10
Registration date
Thursday March 6, 2014
Status
Member
Last seen
August 18, 2020
-
Mar 6, 2014 at 12:56 AM
ad1959 Posts 10 Registration date Thursday March 6, 2014 Status Member Last seen August 18, 2020 - Mar 6, 2014 at 07:25 PM
ad1959 Posts 10 Registration date Thursday March 6, 2014 Status Member Last seen August 18, 2020 - Mar 6, 2014 at 07:25 PM
Related:
- Compare Column A to Column B and return Column C
- Vba find column by name ✓ - Excel Forum
- Auto serial number in excel based on another column ✓ - Excel Forum
- Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Excel Forum
- If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
- Sum column if another column equals ✓ - Excel Forum
2 replies
Mazzaropi
Posts
1980
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
December 22, 2022
146
Mar 6, 2014 at 04:17 AM
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
Posts
10
Registration date
Thursday March 6, 2014
Status
Member
Last seen
August 18, 2020
1
Mar 6, 2014 at 07:25 PM
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.