USING IF ISTEXT OR ISNUMBER THEN INDEX MATCH OR calculation

**pippib** · 10-16-2012, 09:21 PM

Hi there,

I have never had to do this type of logic before so hopefully someone can help me out.

Based on a cell value being Text OR Numberic I need to return either and Index Match calclation or a straight Cell C35 * E35

Can anyone help.

So the formula for is currently for Text only :

=INDEX(RampUp,MATCH($C34,RowHead_RampUp,0),MATCH(G28,ColHead_RampUp,0))*$E35*(VLOOKUP(G30,$CE:$CF,2,0))

When I add in the ISTEXT logic, the result I am getting is True or False and I need the result to be a numeric calculation:

=IF((ISTEXT((INDEX(RampUp,MATCH($C34,RowHead_RampUp,0),MATCH(F28,ColHead_RampUp,0))*$E35*(VLOOKUP(F30,$CE:$CF,2,0))))), $C34*$E35)

Please let me know if you need anything more to help :-)

**FDibbins** · 10-17-2012, 12:51 AM

you dont have a 3rd part to your if() statement....

if(criteria,true,false)

=IF( ISTEXT(INDEX(RampUp,MATCH($C34,RowHead_RampUp,0),MATCH(F28,ColHead_RampUp,0))*$E35*(VLOOKUP(F30,$CE:$CF,2,0))), $C34*$E35,C35 * E35)

also, you have a few extra () in there that you dont really need, so i removed them