# SUMIF where sum_range consists of text strings?

1. ## SUMIF where sum_range consists of text strings?

Hi,

I have a worksheet where I want users to choose a value from a validated list, and based on their chosen value I want to collect various text strings from other parts of the sheet, and present it to the user. Normally I would use SUMIF, but the sum_range in my sheet is text, so it doesn't work.

Let's say the user selects a value in the first cell (A1=Train). Based on that I want to find that selection in B1:B3 (Bike, Train, Plane) and give the corresponding value from C1:C3, where these values are text (Cheap, Efficient, Fast), and present the result in, say, cell A2, so that A2=Efficient.

Is there another function that works for this?

Any help would be appreciated!

2. ## Re: SUMIF where sum_range consists of text strings?

Use VLOOKUP()

3. ## Re: SUMIF where sum_range consists of text strings?

Originally Posted by WinteE
Use VLOOKUP()
Can I use VLOOKUP() on unsorted lists? The order of the data in columns B and C (given the example) bears significance, so I can't sort them alphabetically.

Hi,

5. ## Re: SUMIF where sum_range consists of text strings?

Originally Posted by WinteE
Use VLOOKUP()
Thanks a lot WinteE! I managed to get it to work with VLOOKUP() when I set the final argument ([range_lookup]) to FALSE. Problem solved!

Originally Posted by nawas
Hi,

Thank you for wanting to help, nawas. As written above, the solution offered by WinteE worked for me.

--
Kind regards,
Arne

There are currently 1 users browsing this thread. (0 members and 1 guests)