Forum Discussion
Return a value from a list depending if value in another cell contains this
See the attached sample workbook. The Parts and Sizes names are dynamic in this version - they will automatically be adjusted when you add or remove part numbers. See Formulas > Name Manager for their definition.
HansVogelaar Don't know if i can post this here or i need a new post enterly?
However the solution given in this threat is very close to what im looking for. Dont know if it is posible tho. To have an open sheet search for words for a not open file.
my problem is that i have many sheets that need to search for the same values and i dont want to update the database across all of the sheets. So if the database/list chould be located only one place then i chould updatse it just once.
excampels in photos:
That is a rather awkward setup. Moreover, you're going to run into problems since "roastbeef" contains "roast". "roast potatoes" would classify as both pork and beef...
- Thats ok ... i thought i chould make a copy from DB to active sheet with ='[DB.xlsx]Ark1'!$A$1:$E$18
but it just returns #Value!
Well thanks for your time
i'll keep looking - ok thanks 🙂
i do think i can you code to work for tho 🙂 is there a way to have value return blank ( " " ) if the word is not found or if the cell that is being searched is blank.