Function for looking up data in a range and display "yes" or "no"
I'm trying to pull some data and can't figure out which formula to use. Here's what I need:
I have a unique ID in my master database. In this same database, I also have a Budget 1, Budget 2, Budget 3 (the budgets are each in a separate column) for each unique ID - see example screenshot (first 4 columns).
I am now pulling those IDs into a separate sheet and need to figure out the following:
Look up the unique ID and display "yes" if that ID has all 3 budgets populated in the master database. If one of the 3 budgets is blank, display "no". What I am trying to accomplish is highlighted in yellow in my screenshot.
Any input how I can do this? I would rather not use vlookup since the master sheet is ever changing and column order changes all the time!
Thank you in advance!!!
Help Article Resources
Check out the Formula Handbook template!