Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup & Match formula
Hi,
I have a worksheet that I send to HQ every week: Col A = Reference Number Col B = Amount Col C = Name etc. At the end of the month HQ sends me a consolidated report for the month (same column headings). Please write me the formula on how to match my "Reference Number" to the consolidated report and see if the "Amount" of the corresponding "Reference Number" is still the same. My weekly report usually has 200-300 rows. The consolidated report is up to 5,000 rows. Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If & Lookup & match Formula Required! | Excel Discussion (Misc queries) | |||
Lookup/match formula? | Excel Discussion (Misc queries) | |||
LOOKUP, INDEX, MATCH (?) Formula | Excel Worksheet Functions | |||
Excel Lookup MATCH formula | Excel Discussion (Misc queries) | |||
lookup? Index? match? formula | Excel Discussion (Misc queries) |