combining two or more formulas

[lovella]

got formulas that work by themselves, but after combining them it returns an error value, can you please help. my formula below:
formula 1 =IFERROR(INDEX(E:E,MATCH(B3,E:E,0)-1),"")
formula 2 =IFERROR(INDEX(F:F,MATCH(B3,F:F,0)-1),"")
formula 3 =IFERROR(INDEX(G:G,MATCH(B3,G:G,0)-1),"")

thanks in advance

 

[Momentman]

How did you combine them?

 

[Marcelo Branco]

Maybe...

=IFERROR(INDEX(E:E,MATCH(B3,E:E,0)-1),IFERROR(INDEX(F:F,MATCH(B3,F:F,0)-1),IFERROR(INDEX(G:G,MATCH(B3,G:G,0)-1),"")))

Hope this helps

M.

 

[lovella]

Maybe...

=IFERROR(INDEX(E:E,MATCH(B3,E:E,0)-1),IFERROR(INDEX(F:F,MATCH(B3,F:F,0)-1),IFERROR(INDEX(G:G,MATCH(B3,G:G,0)-1),"")))

Hope this helps

M.

whoaaaa sweet as , thanks marcelo , it works like a charm!! am a newbie on this. Thanks heaps.!

 

[Marcelo Branco]

whoaaaa sweet as , thanks marcelo , it works like a charm!! am a newbie on this. Thanks heaps.!

You are welcome and thanks for the feedback.

M.