I need to figure out how to make the "rate" column show the right rate when I type the contractor type into the "contractor" column based on the contractors and rates...
(See pic) https://cdn.geekzone.co.nz/imagessubs/blog1515ff08438b877638b04b190bdd34a0.jpg
Do I use an IF function or a LOOKUP function, can anyone tell me the formula?
This is driving me (more) mental!
PS: I'm a noob here so I'm really sorry if I posted this in the wrong place :(