Lookup Column and Vlookup another SP List to Find Charegout Rate

Brass Contributor

I have an SP list with Employee as Choice Column and a number column. I thne have a main list that charges out per hours depending on the person assigned. So I f I put BOB down, I want a column that can then lookup BOB and Apply £50 rate an hour. I can then setup a calculated column to times these values.


Any idea how to ahcieve this?

0 Replies