Hi all.
I was wandering if it is possible to make a searchable database in Excel. Here's what I would like to be able to do.
Select recipe from a list.
Excel views the ingredients required as well as what ingredients I have in my inventory.
Returns a list of which ingredients I do not have.
Is this possible with Excel? Or would I need to look into something else?
Yes it is possible as per your describing in words. Any way, try to attach a worksheet with your expected format and results.
Quang PT
I havent got that far yet. What I would like is a list of recipes. When I click on a recipe it searches my current stock based on an inventory that I have. Then it reports what I am missing to make that recipe. I am quite new to excel
Kindly see yellow banner on top page. Its helpful of both to clear understanding. hence attach your sample file with desire result.
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks