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
Hello
Is there a way to get excel to autofill a number on sheet 1 that comes from the column "B" on sheet 2; if the text in column "A" matches?
For example, on Sheet 1 I have a list of SKU's and a blank column called O/O.. I would like to do a formula where it will search for a specific SKU (column A in sheet 2) and pull the In Stock QTY (from column B Sheet 2)
Thank you!!!
Is there a way to get excel to autofill a number on sheet 1 that comes from the column "B" on sheet 2; if the text in column "A" matches?
For example, on Sheet 1 I have a list of SKU's and a blank column called O/O.. I would like to do a formula where it will search for a specific SKU (column A in sheet 2) and pull the In Stock QTY (from column B Sheet 2)
Thank you!!!
System Configuration: Macintosh / Safari 11.1
Related:
- Autofill number from Column B based upon text in Column A
- How to delete column in word - Guide
- Display two columns in data validation list but return only one - Guide
- Tweetdeck expand column - Guide
- Excel count occurrences of string in column - Guide
- 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