I have created a calc sheet at work which allows colleagues to select a name from a drop down list. Once a name is selected, the cell next to the list is supposed to generate a contact id number using the formula =VLOOKUP(C2;Sheet2.$B$1:$C$243;2;0).
My problem is vlookup isnt generating the correct contact id and I cannot figure out why not! Please help!!