Match & IF

  • Thread starter Thread starter Martinc126
  • Start date Start date
M

Martinc126

I have Two Sheets CP1 and CP2

I want it so that in sheet CP2 on E9 it gets the Course ID from D9 (Example
0001) and searchs Sheet CP1 B9:B100 for the code from CP2!D9 (Been 0001) and
if it finds it to display the data from Cell C:C (Course Name) from the same
row where the Course ID Matched CP2!D9

Not sure if i've explained that very good.

Any help would be great.

Thanks

Martin
 
Martinc126 said:
I have Two Sheets CP1 and CP2

I want it so that in sheet CP2 on E9 it gets the Course ID from D9 (Example
0001) and searchs Sheet CP1 B9:B100 for the code from CP2!D9 (Been 0001) and
if it finds it to display the data from Cell C:C (Course Name) from the same
row where the Course ID Matched CP2!D9

Not sure if i've explained that very good.

Any help would be great.

Thanks

Martin
Click to expand...


Try here:

http://www.contextures.com/xlFunctions02.html
 
Back
Top