Autofill number from Column B based upon text in Column A
Closed
alawson90
Posts
1
Registration date
Monday November 19, 2018
Status
Member
Last seen
November 19, 2018
-
Nov 19, 2018 at 09:09 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 20, 2018 at 11:22 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 20, 2018 at 11:22 AM
Related:
- Autofill number from Column B based upon text in Column A
- Display two columns in data validation list but return only one - Guide
- How to delete column in word - Guide
- Tweetdeck remove column - Guide
- Convert row to column in notepad++ ✓ - Excel Forum
- Based on the values in cells b77 b81 c77 - Excel Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Updated on Nov 20, 2018 at 11:22 AM
Updated on Nov 20, 2018 at 11:22 AM
Hi Alawson,
You will want to use VLOOKUP for that:
=VLOOKUP(A2,Sheet2!$A$2:$B$100,2,0)
Change the number in $B$100 to the max row number of sheet2. Drag formula down.
Best regards,
Trowa
You will want to use VLOOKUP for that:
=VLOOKUP(A2,Sheet2!$A$2:$B$100,2,0)
Change the number in $B$100 to the max row number of sheet2. Drag formula down.
Best regards,
Trowa
