Autofill number from Column B based upon text in Column A

Posts
1
Registration date
Monday November 19, 2018
Last seen
November 19, 2018
- - Latest reply: TrowaD
Posts
2435
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 4, 2018
- 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!!!

System Configuration: Macintosh / Safari 11.1
See more 

Your reply

1 reply

Posts
2435
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 4, 2018
0
Thank you
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

Respond to TrowaD