Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding test strings in a row which are missing from a column
I want to use the LOOKUP function to auto enter values in colums. Each column
is headed with the account nmumber. The amount spent for that account the prevuious day is presented in a report, in which one of the columns shows account numbers. If one of the accounts has a zero spend, it does not appear in the report, and there are many old accounts no longer spending. In order to copy the spend from the previous day from the culumnar report I desire to ue the LOOKUP function, but that will return an error (which I can deal with easily) or incorrect data (more common and which I cannot deal with so easily or at all) I have been through all the fundctions I can find, and I have been through the enttire knowledge base but I cannot find anything to match what I need. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display missing Part Number if Column A does not match column B | Excel Worksheet Functions | |||
Conditional Format as a MACRO | Excel Worksheet Functions | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
match and count words | Excel Worksheet Functions | |||
Finding Duplicate text strings with a single column | Excel Worksheet Functions |