View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] atrscomputers@gmail.com is offline
external usenet poster
 
Posts: 21
Default Range Comparison

Hey,

I have 2 worksheets, 1 with a range of data and the 2nd with the data
codes and english descriptions. What i want to do is compare the range
thats in the data worksheet and compare it with column a of the codes
work sheet. If the code matches something in column a i want it to
print the description of that code, being whats beside it in column b.
please help a newb out.

Thanks
Andrew