Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range Comparison
Take a look at the VLookup Formula in the help menu.
-- HTH... Jim Thomlinson " wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range Comparison
Perfect
Thanks When you've been doing VB and Foxpro stuff all day you forget the simple things. :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
row comparison | Excel Worksheet Functions | |||
comparison | Excel Worksheet Functions | |||
Boolean comparison: range vs. single cell | Excel Worksheet Functions | |||
Workbook comparison results in subscript out of range error | Excel Programming | |||
Comparison | Excel Programming |