hi
im scanning barcodes into A column and want b column to put description of item in column in B
I am trying to create a inventory sign out, sign in page for search and rescue
Thanks Barry
Excel Facts
What do {} around a formula in the formula bar mean?
Use Tables. Column B would utilize a VLOOKUP referencing a Table where you list the Inventory.
Using Tables allows Excel to Fill down the formula as you add new rows. Reference a Table in a VLOOKUP will always expand as the Table grows with additional inventory.
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.