On Aug 29, 1:36*am, "Max" wrote:
Welcome
--
Max
Singaporehttp://savefile.com/projects/236895
Downloads:17,500, Files:358, Subscribers:55
xdemechanik
---
"Chris" wrote
Yes, you are right. I got it to work after a while, thanks for the
extra tips and for your help.

What would I need to change in the formula if I wanted to match 2
columns instead of one. For example,

sheet1 has a 'JobCode' in column C and 'DepartmentID' in column E
sheet 2 has a 'JobCode' in column A and 'DepartmentID' in column D
with an associating 'Level' in
column E.


What if I wanted to match column C and column E in sheet one to column
A and column D in sheet2 before returning the associating 'Level' in
column E on sheet2?