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 January 16, 2023 - Nov 20, 2018 at 11:22 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Nov 20, 2018 at 11:22 AM
Related:
- Autofill number from Column B based upon text in Column A
- How to convert row to column in notepad++ ✓ - Excel Forum
- Excel create sheets based on column ✓ - Excel Forum
- How to increment numbers when value changes in another column? - Excel Forum
- Vba autofill to last row ✓ - Excel Forum
1 reply
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
547
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
