Forum Discussion
LOOKUP function not returning correct value
Riny_van_Eekelen Thank you so much that worked! although the system put *1 at the end instead of just a 1. but everything works great.
But it is still doing something weird. for some reason, It wont let me select the same job # more than once. (see new attached).
And also, the dependent list that I created in column F refuses to see the values for the "60ft Dive Boat Overhaul" Job Name. the others seem to work but not that one. What am I doing wrong?
noeoliver First of all, you need to fix the column and row references in the INDEX/MATCH formula. Could also replace the * with a comma. Don't understand where that one came from.
Secondly, named ranges may not begin with a number, so I changed the item that caused a problem to
" 60ft DIVE BOAT OVERHAUL". Note the extra space in the beginning. The SUBSTITUTE function in the data validation rule will now also replace that space by an underscore. And then I also changed the name of the corresponding named range from "_60_DIVE_BOAT_OVERHAUL" to "_60ft_DIVE_BOAT_OVERHAUL".
Now all seems to work OK! See attached.