Categories
User Help Web Apps

Data row lookup in separate big data sheet and placing it inside another sheet in Google spreadsheet

I would like to make a Google spreadshit for calorie tracking. In my head I imagine it as I would like to have a sheet where I will record daily food activity. And another DB sheet with all time consumed food types with their parameters. So, the idea is when I type food name in daily diary sheet it will lookup in DB sheet if I already recorded this food macros and the food exists it just places reference to the existing food or copies its parameters. So, my question is it possible to implement something like spotlight? When I type some characters it displays kind of popup with suggestions based on DB sheet data and if I choose popup element it gives me a reference to that data. Ideally it would be great to have a fuzzy search. Maybe someone knows in which directions may I start to research or some impelemnted solutions?

Leave a Reply

Your email address will not be published. Required fields are marked *