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.
This looks like something i have been strugeling with ... However. Is it posible to the two sheets as two different files insted of inside the same worksheet?HansVogelaar
It's possible but I would not recommend it. The workbook with the lookup list would have to remain open, otherwise the formulas would return an error. That kind of defeats the purpose.
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
HansVogelaar Thanks for the quick answer. I see your point. Just to bad for me 🙂