Need nested formula for my one line horizontal data

**arman29** · 08-17-2014, 09:26 AM

Can somebody help me with this please, thank you...

Data110.xlsx

**sktneer** · 08-17-2014, 10:06 AM

Try this.....

In B9

Please Login or Register  to view this content.

Is this what you are trying to achieve?

**arman29** · 08-17-2014, 10:42 AM

No, it does not work, all I need is a to combine the "if" formula from yellow highlighted cell from lemons to apples, assuming the date is a one line horizontal, I have no idea how to combined all those, thanks. so i believe index match does did not achieve the result i want. and I am expecting the on B9 result should be "apple". I hope you may help me the other way around, thanks