Hi,
I need some help with a function. I'm trying to search through multiple cells in a column to find specific values listed in a separate column. If one of the values is found, I would like it to return just that value into a separate cell in the same row as the cell in which it was found.
In the attached spreadsheet, I need a formula to look for all the values in column D in the cells of column A, and if found return the value into the cell in column E. Basically I'm trying to locate and extract specific information from column A.
I've been playing around with combinations of the search and lookup functions, but to no avail. Is this possible?
Last edited by NBVC; 07-07-2011 at 02:10 PM. Reason: Based on Rep given
Not sure I understood fully, but this formula:
=LOOKUP(9.999999E+307,SEARCH($D$1:$D$4,A1),$D$1:$D$4)
will extract whichever value from D1:D4 is contained in A1 and enter that value in E1...
Copying down with check against A2, A3, and so on....
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks