Formula not picking up reference data - ANSWERED MY OWN QUESTION

BettyJo

The formula below was working correctly when I had it reference a certain data sheet. I copied the formula, slightly changed the range names (added the word GRAY) and referenced a different data sheet for those ranges. The formula does not pick up the data - just gives me "0".

I've verified the references are correct and see no error in the formula. Any advice on what else could be wrong?

The issue is the quotations around 134…number only criteria does not require quotations.

Jgorsich

Kudos to you for both finding the answer and updating your post (which will help some future person when they find it via a search engine).

Specifically - just to help in similar situations - adding the quotes makes it into a text string and not a number. You could run into the problem in reverse as well - say the EBOM Tag ID is formatted as text for some reason (say, for example, you used a right() function to extract it from a product name), then looking for where it equals the numeric 134 would also fail. You can use the value() function to convert a text 134 to a numeric 134 if ever needed.

BettyJo

Thanks for the tip! Much appreciated!