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
- Excel copy column from one sheet to another automatically - Guide
- How to convert column to row in notepad++ ✓ - Excel Forum
- Auto serial number in excel based on another column ✓ - Excel Forum
- Display two columns in data validation list but return only one - Guide
- Excel count how many times a value appears in a column ✓ - Office Software Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
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
