Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Match help
Hello,
Report One In Column A I have account numbers from one report, In Column B:H is the data that I'm counting. Each column has headers. Not all cells have data returned, but when it is returned it shows a 1. Report Two In column J I have account numbers from the second report In Columns K:Q is the data that I'm counting Each column has headers. Not all cells have data returned, but when it is returned it shows a 1 What I need help with, is matching column A and J and then matching columns B:H and K:Q. I need to be alerted if any of the data is different. I hope this is clear. And thank you very much for the help. Jim |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to match 2 columns, if a match found add info from 2nd column | Excel Worksheet Functions | |||
index(match) Wind Uplift Calculations (match four conditions) | Excel Worksheet Functions | |||
MATCH Multiple Criteria & Return Previous / Penultimate Match | Excel Worksheet Functions | |||
index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
Lookup? Match? pulling rows from one spreadsheet to match a text f | Excel Worksheet Functions |