LinkBack URL
About LinkBacks
Hi All,
I am trying to search for multiple values in a cell with Multiple criteria.
E.g: Please find attached the sample excel data
I tried using VLOOKUP which is not working as I am having multiple values in column A.
Any help and suggestions
Hi All,
I am trying to search for multiple values in a cell with Multiple criteria.
E.g: Please find attached the sample excel data
I tried using VLOOKUP which is not working as I am having multiple values in column A.
Any help and suggestions
Last edited by itsmeddb; 05-22-2009 at 04:02 PM.
Unclear... Can you provide the actual results you expected?
Domenic, I am trying to display the Column C value in column D if the value in B is present in Column A Cell.
Try...
D1, copied down:
=IF(ISNUMBER(SEARCH(B1,A1)),C1,"")
i am trying to use a range of value to look for and display the corresponding values.
i tried the below formula which didnt work..
=IF(ISNUMBER(SEARCH(B1:B3,A1)),C1:C3,"NA")
Please let me know if this can be workout someother way.
Where's your list of values for which to search? It would help if you provided some examples...
I apologies for not being clear in explaining what is that i am trying to accomplish.
I am attaching the sample data.
I am trying to search for the Name - Column B range in Column A- Description cell: A2 and display the corresponding value from Column C in column D, if found.
In my sample data :
Nakkash is present in A2 and A3 so D2 and D3 Should say COG.
Madassam is present in A4 so D4 should say WIN
I am trying to perform the same for some 20000 records.
Last edited by itsmeddb; 05-22-2009 at 10:41 AM.
Try...
D2, copied down:
=LOOKUP(9.99999999999999E+307,SEARCH(" "&$B$2:$B$4&" "," "&A2&" "),$C$2:$C$4)
Try this,
D2
Press Ctrl+Shift+Enter after input this formula, then copy down.
=IF(SUM(--($B$2:$B$100<>"")*ISNUMBER(SEARCH($B$2:$B$100,A2)))=0,"NA",INDEX($C$2:$C$100,MATCH(1,($B$2:$B$100<>"")*ISNUMBER(SEARCH($B$2:$B$100,A2)),0)))
Hope this helps,
windknife
Domenic... i was able to accomplish my goal using your condition.. Thanks for the timely help..
Thanks Wind as well..
Marking as resolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks