Hey to everyone,
Been cracking my head with this puzzle.
I have 4 Columns, A - B and D - E in the same sheet.
Columns A and D contains id numbers, columns B and E contain categories written in Greek.
i want a function that does:
looks in column D for specific partial text given by user and if it finds a match (for example E90) then it copies the corresponding id (D90) from column D to column A (A90).
thnx in advance
Could you please upload the sample file.....
here it is. thanks for the response
so in this example, i want a function to put in each cell in column a that searches for partial text "example1" and if it finds a match, it takes the id from column D as a result
PS: case insensitive partial text
Last edited by bbb13; 04-02-2015 at 07:21 AM.
Hey thanks for the attachment....
Could you please try this one...if you are looking for different thing..pls let me know..
Formula:
Please Login or Register to view this content.
Last edited by LokeshKumar; 04-03-2015 at 03:01 PM.
Here's another way to write that:=IF(NOT(ISERROR(SEARCH("Example",B2))),D2,"")
=IF(COUNT(SEARCH("Example",B2)),D2,"")
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks