Populate the value of a specific cell based on two other dependant validation lists

its the space as mentioned at the end of individual
on the first sheet the validation looked for
individual with a space at the end
try this
=IF(A40="individual", LOOKUP(B40,{"Private individual";"Prospect customer";"Wesbank"},{"01";99;14}),VLOOKUP(B40,JurNrLookup,2,FALSE))
with the changes needed for your version , to ;