Help with Lookup Function

[verbena]

I need help building a lookup function. I have 4 columns. Column A is the number value I want to lookup on column C to find an exact match. When found, I want the text value on column D to be placed on Column B.

Any help would be greatly appreciated.

 

[Fluff]

How about

=VLOOKUP(A2,$C$2:$D$100,2,0)

 

[verbena]

thank you....

 

[Fluff]

You're welcome & thanks for the feedback.