• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Need Help.. 3 cells have error.. why?

Yes sir.. I will use it with iPad: Quick Office, Docs To Go and Wps Office...

I think you are right nesting formulas make it down.

I made a table and I need a formula for this table. Could you please check it and help me with the formula?

(Attached...)
 

Attachments

  • New need fix.xls
    26 KB · Views: 12
While I do not have any idea if the formula I am posting will work with the environments you have mentioned. It works in Excel - Windows environment.

You need to CTRL+SHIFT+ENTER following formula in C5.
=INDEX(C9:C27,MATCH(C4,--TRIM(LEFT($B$9:$B$27,FIND("-",$B$9:$B$27)-1))))
and then copy across
 
Thanks for the formula but Quick Office at iPad doesn't support Index - Match formulas. But it supports vlookup. Can you give that formula which suits me?
 
OK. Does the following work:
In A9 write following formula:
=--TRIM(LEFT(B9,FIND("-",B9)-1))
and copy down.

Then in C5 write following VLOOKUP:
=VLOOKUP(C4,$A$9:C27,COLUMN(C4))
and copy across.
 
Thanks for the formula but Quick Office at iPad doesn't support Index - Match formulas. But it supports vlookup. Can you give that formula which suits me?
 
shrivallabha said:
OK. Does the following work:
In A9 write following formula:
=--TRIM(LEFT(B9,FIND("-",B9)-1))
and copy down.

Then in C5 write following VLOOKUP:
=VLOOKUP(C4,$A$9:C27,COLUMN(C4))
and copy across.
Click to expand...

It is my mistake. I worked on your formula and it is working fine..

Thank you very much.. :)
 
You must log in or register to reply here.
Back
Top