Hello
I am looking for a function similiar to a SUMIF function that will work with text and not numbers. For example:
Row 1 = Name of Different Fruits
Row 2 = Color of each fruit
In row 3, Column A, I want to be able to type the name of the fruit, and in Column B, I want the color of that fruit to be displayed.
The function should search the range for the name of the fruit, and then answer with the corresponding cell below the fruit name.
Thanks!
Perjaps something like this?
=index(b2:iv2,match(a3,b1:iv1,0))
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Ultimately I need it to refer to other worksheets. Does index work with closed worksheets?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks