Which of those three elements are you looking for? Shouldn't be a problem;
check this out:
http://www.contextures.com/xlFunctions03.html



--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


" wrote:

col A the city were the employee located,
col B the emploee #1234
Col C the employeee name

OK simple vlookup right,

well on sheet 2 the data is different
col A agent #
Col B agent Name
col C agent city

how do I go brackwards