Forum Discussion

Copper Contributor

Oct 17, 2018

Solved

Linked files

Hello everyone, First time I join this community. Here is my (complex for me) query. I have one file with a list of ingredients, suppliers, prices. Then I have individual files with recipes. Each ...

excel

Lorenzo Kim
Oct 17, 2018
here are some sites you can visit:
https://exceljet.net/excel-data-validation-guide
https://www.howtoexcel.org/tips-and-tricks/11-awesome-examples-of-data-validation/
good luck..

Lorenzo Kim

Bronze Contributor

Oct 17, 2018

pls find attached file.

hope you can work something out of it.

thanks..

jean.xlsx22 KB

JEAN YVES CHATTE
Copper Contributor
Oct 17, 2018
Thanks Lorenzo,
Do you mean using filters?
Jyc
- Lorenzo Kim
  Bronze Contributor
  Oct 17, 2018
  no, I don't use filters. just plain Data Validation and vlookup.
  hope that it will get you going with your project.
  thanks..
  - JEAN YVES CHATTE
    Copper Contributor
    Oct 17, 2018
    Looks great. Thanks.
    I am not familiar with Data Validation but will look at tutorials.
    Jyc