Hype Blast

Home / updates

Google Sheets Data Validation has error that says "Input must fall within specified range" even though it does

Mia Tucker |

I have a pretty complex google sheet, at least for me, that has 2 dependent dropdown menus. For some reason my second dropdown menu is returning an error.

Picture showing error on dropdown

I don't know why it's returning this error because that value DOES fall within the specified range.

Picture showing data validation range

As you can see the range has each of those values. Why would I be getting this error?

Below is a link to a copy of the google sheet I'm working on. I set it to viewer only so no one messes it up before you can look at it. Just make a copy of it and see if you can diagnose what I'm missing.

2 Answers

The format of your cell is wrong.
Change it from Plain text to Automatic

enter image description here

1

either the above or change MasterDataValidation!M1 to:

=INDEX(TRANSPOSE(IF('Legrabox Drawer Cutlist'!D6=FALSE, INDEX($A$11:$E$16,,MATCH('Legrabox Drawer Cutlist'!F6, $A$10:$E$10, )), INDEX($B$20:$E$24,,MATCH('Legrabox Drawer Cutlist'!F6, $B$19:$E$19, )))&""))

enter image description here

enter image description here

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password

Post as a guest

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

You Might Also Like