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
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

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
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