Hi all users
I have for several times been searching the web for answers on certain Excel challenges that I've had.
I have come across this forum a few times, and now it was the time to sign up for it :-)
And I have a challenge which I hope that you can help me with.
I have a long list (approx. 1500) of cells which consist of text strings.
This would be an example on 7 of the cells:
D.Eng C LC2A-NL30 11/10-F-12-1760
D.Eng C LC2A-NL30 11/10-F-12-1800
D.Eng C LC2A-NL30 13/12-F-12-2000
D.Eng C LC2A-NL30 14/13-F-12-2100
D.Eng C LC2A-NL30 15/14-F-12-2200
D.Eng C LC2A-NL30 15/14-F-12-2350
D.Eng C LC2A-NL30 16/15-F-12-2400
What I need here is a way to search for certain keywords within the list of cells, and if I have a match for all of the keyword, I would like to return the content of the found cell.
I think another example would be good.
Keyword 1: NL
Keyword 2: 2000
Keyword 3: 10
I need to find a cell where keyword 1 and keyword 2 is included.
Furthermore I need the value after the / to be equal or higher than keyword 3.
In this case there is a cell that lives up to all of this (number 3 from the top) and then I would like to return the content of this cell.
In my world this isn't really that simple, so I really hope that you guys can help me.
Thanks in advance
- CLARK
Bookmarks