Value returning as False in openasapp but not in excel
This is my first attempt at an app from spreadsheet in openasapp. I have a dropdown that has 4 possible options (B5). Each option will reference a different table later in the sheet to return the proper value for that option. The problem is that only one of the dropdown options returns a value ( "320 NEO" ) in the 2 places that I need it to in openasapp even though it works in excel. I can't see anything different about the way that one option is written compared to the others so I am at a loss at how to fix it. Ive tried changing the values at B5 to numbers instead of words to eliminate the "" but that hasnt worked. Maybe it is just written poorly I dont know.
first place I get an error
=IF($B$5=319,MAX(INDEX(L60:O62,MATCH(D5,K60:K62,1),0)),IF($B$5=320,MAX(INDEX(L60:O62,MATCH(D5,K60:K62,1),0)),IF($B$5=321,MAX(INDEX(L60:O62,MATCH(D5,K60:K62,1),0)),IF($B$5="320 NEO",MAX(INDEX(L75:O77,MATCH($D$5,K75:K77,1),0))))))\
second place I get an error
=IF($B$5=319,INDEX($L$51:$T$51,MATCH(B17,$L$50:$T$50,-1)),IF($B$5=320,INDEX($L$55:$V$56,MATCH($C$17,$K$55:$K$56,1),MATCH($B$17,$L$54:$V$54,-1)),IF($B$5=321,INDEX($L$66:$T$66,MATCH(B17,$L$65:$T$65,-1)),IF($B$5="320 NEO",INDEX($L$70:$T$71,MATCH($C$17,$K$70:$K$71,1),MATCH($B$17,$L$69:$T$69,-1)),0))))
-
Official comment
Hi Aaron,
Thanks for your message.
Feel free to drop us a message at support@openasapp.com and send us a short video explaining how your spreadsheet works, maybe two three sentences how the user should use the app.
Based on what you've said here, I can offer very little help at this time.
Best regards,
Kaspar
Comment actions
Please sign in to leave a comment.
Comments
1 comment