Excel Lookup Formula
Posted on 2012-09-10
I have an excel sheet with two columns. Column A has words like Chest, Head, Legs, etc. Column B has a 6 digit number.
What I am struggling with is an advanced VLOOKUP formula. I can tell it to give me the value of column B if it finds a particular string in ColumnA, but what I want is far more flexibility.
2V Chest 123456
Head Angio 234567
Small Bowel 345678
Chest Angio 456789
What I would like is to have a formula that searches for the string 'Chest' and in the results, it would give me 123456,456789. It would return these two, because they are the two numbers that are associated with anytime the word 'Chest' appears.
Is something like this possible?