Check out Vlookup in Excel Help. An example of using this would be:
which is telling Excel to look up the value in cell A1 of the current sheet (could be a name like Fred or a number) in the A column of sheet2 (cells 1:100) and return the contents of the 3rd column on the same line (ie the C column). The 0 on the end of the vlookup specifies an exact match.
Okay the formula worked but...I'm also using an auto filter on all of my columns and every time I filter it gives me of the way results. It works if my first column is sorted by accending, but every other filter causes the formula to pull the wrong name out of column C.
There's an optional 4th argument to Vlookup - at present you have it set to True (as that's the default) which means it requires the lookup range to be sorted. You can set it to falase which effectively means the vlookup will only return a non-error value if it finds an exact match in the lookup range (and this might be perfectly OK for you depending on your needs):