ExcelBanter - lookup inventory to a receipt

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - lookup inventory to a receipt (https://www.excelbanter.com/excel-discussion-misc-queries/138477-lookup-inventory-receipt.html)

lauras03

lookup inventory to a receipt

Hi,
I have a receipt I have made up and would like to have a master inventory
list and be able to enter the sku # on the reciept and have it fill in the
rest from the master sheet. Is this possible?
--
Thanks,
Laura

dlw

lookup inventory to a receipt

Excel has the VLOOKUP function that will do that.

"lauras03" wrote:

Hi,
I have a receipt I have made up and would like to have a master inventory
list and be able to enter the sku # on the reciept and have it fill in the
rest from the master sheet. Is this possible?
--
Thanks,
Laura

All times are GMT +1. The time now is 02:21 AM.