Matching data from different tabs

[RodneyW]

My destination cells are column B, rows 2 through 40000 in a tab named CMM. In every row of column C on the same tab, I have an ID number which is used to reference content on another tab named ID's

I need a formula I can place in B2 (then drag down) on the CMM tab that will see the value in C2, look for the same value in C2:C125 on the IDs tab. When they match I want the value in column B from the ID's tab to populate B2 on the CMM tab. To explain a little further, lets say the value from C2 on the CMM tab is matched by the value in C17 from the IDs tab. When this happens, whatever the value in B17 is on the IDs tab, should populate B2 on the CMM tab.

Thank you in advance

 

[Fluff]

How about
=Index('ID''s'!B$2:B$125,match(C2,'ID''s'!C$2:C$125,0))

 

[RodneyW]

Comes back with #N/A error

 

[Fluff]

What is the exact name of the ID sheet? You have spelt it in two different ways.

 

[RodneyW]

IDs

 

[RodneyW]

It works now. TY

 

[Fluff]

In that case use
=Index('IDs'!B$2:B$125,match(C2,'IDs'!C$2:C$125,0))