Thread: prob with logical function

before
http://img340.imageshack.us/img340/7429/excelbefore.png

After (example 1)
http://img856.imageshack.us/img856/6449/exceleg1.png

After (example 2)
http://img62.imageshack.us/img62/1055/exceleg2.png

After (example 3)
http://img683.imageshack.us/img683/8691/exceleg3.png


referring to the example given, can anybody generate a formula for B6 and C6
so that wherever i put the amount in row 2, the result will always be in B6 and C6 according to mod (model number) selected.

your kindness is much appreciated

sorry for the unappear image

Hi,

I think this should be what you are looking for.

Thanks a lot teelim...you're really life saver

=INDEX(A2:H2,(MATCH(C4,A2:H2,0))-1)

can i change the cell into blank rather than 0?

Originally Posted by Omastar

Thanks a lot teelim...you're really life saver

=INDEX(A2:H2,(MATCH(C4,A2:H2,0))-1)

can i change the cell into blank rather than 0?

You are welcome.

To change it to blank, I added an "IF" function to it.

Originally Posted by Omastar

thanks again but i think Book1a got problem with the formula
the result was incorrect

whoops... sorry, my bad.

here is the corrected one.