Sumproduct function showing text

**Domyzon** · 10-28-2011, 03:37 PM

Hi!

I have problem with SUMPRODUCT function, I have saved it as an attachment in excel.

Basically, instead of showing the answer as a number, I would like it to show it as a text.
I have explained the problem visually in the excel file.

Thanks,

Marty

**zbor** · 10-28-2011, 03:40 PM

Try this:

=LOOKUP(B9, I12:I18, G12:G18)

**Domyzon** · 10-28-2011, 04:26 PM

works like magic

thanks mate!

**zbor** · 10-29-2011, 02:29 AM

NP, now you see that writting some function name in title don't have sence
since result might be totally different of your expectation.
Rather focus on explanation of the problem.