Vlookup/match?
On Aug 29, 12:46*am, "Max" wrote:
Assume data in row2 down
In Sheet1,
In G2: =INDEX(Sheet2!E:E,MATCH(C2,Sheet2!A:A,0))
Copy down
--
Max
Singaporehttp://savefile.com/projects/236895
Downloads:17,500, Files:358, Subscribers:55
xdemechanik
---"Chris" wrote in message
...
Can anyone help me out with creating a formula that does the
following.
sheet1 has a 'JobCode' in column C
sheet 2 has a 'JobCode' in column A with an associating 'Level' in
column E.
I need to match the JobCode from sheet1 and sheet2 and pull the
associating 'Level' in column E on sheet2 back to sheet1 in column G.
Any help is greatly appreciated.
Thanks,
Chris- Hide quoted text -
- Show quoted text -
It gave me a NA
|