Home |
Search |
Today's Posts |
#1
|
|||
|
|||
compare two groups of data
I am using excel 2002. I have two groups of data in one spreadsheet that I
am trying to comare. Here is my example: Column A = value of a statement cycle, Column B account number, There are 4000 statement cycles and 4000 account numbers. Column C with 33,000 account numbers, column D = value of 33,000 statement cycles. In a seperate column I need to compare the two account number columns, if the number is in both B & C then I need to know what the value is in D and return that answer. Since there are more account numbers in C than B I can not seem to make VLOOKUP work, but that function really confuses me. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
compare data in the same column on separate worksheets | Excel Worksheet Functions | |||
Compare data in two columns to find duplicates. | Excel Discussion (Misc queries) | |||
Help with data not getting plotted | Excel Discussion (Misc queries) | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |