Forum Discussion
Solved
automate data entry
hi, i work on a lot of inventory data entry and still do it manually. this is how i do it, ctrl+F the product name, and enter the amount of product inventory on the next cell. is there any way to eli...
thank you for response. would you enlight me with that, i would try it .. and hope it could be the answer i searched for.
- The formula is
=INDEX (tblInventory[Inventory], MATCH( I5, tblInventory[Product], 0) )
for more details on this check out my blog here
https://accessanalytic.com.au/index-match/