use, in C40
=IF(A40="individual ", LOOKUP(B40,{"Private individual","Prospect custmer","wesbank"},{"01",99,14}),VLOOKUP(B40,JurNrLookup,2,FALSE))
NOTE in individual you have a space after the word
use, in C40
=IF(A40="individual ", LOOKUP(B40,{"Private individual","Prospect custmer","wesbank"},{"01",99,14}),VLOOKUP(B40,JurNrLookup,2,FALSE))
NOTE in individual you have a space after the word
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks