Find Text in a Range of Text
Example I have three columns:--
Column A has the items I want to seach for
Column B has the range of items that I want to search if A exist in this list
Colum C is the result for each item in A
I have tried using =IF and COUNT functions but cannot get these to work
Ta
I hope this is what you require:
Find The value in column A in a list which is in column B
The formula is in Column C:
Put this in C1:
=MATCH(A1,$B$1:$B$13,0)
=VLOOKUP(A1,$B$1:$B$13,1,FALSE)
Looking for great solutions but hate waiting?
Seach this Forum through Google
www.Google.com (e.g. +multiple +IF site:excelforum.com/excel-general/ )
www.Google.com (e.g. +fill +combobox site:excelforum.com/excel-programming/ )
Ave,
Ricardo
Got that to work. Thanks a mill
Please close thread
Looking for great solutions but hate waiting?
Seach this Forum through Google
www.Google.com (e.g. +multiple +IF site:excelforum.com/excel-general/ )
www.Google.com (e.g. +fill +combobox site:excelforum.com/excel-programming/ )
Ave,
Ricardo
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks