Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find a Range of Data
XL 2002
I have a seriously complicated spreadsheet, consisting of multiple worksheets that I am constantly updating. I would like to replace a Lookup formula with something that will return a range of data values. Currently, I have a formula that looks like this =-Lookup("4020 AL",TrialBl!$A$1:$B$2109)-Lookup("4020 AR",TrialBl!$A$1:$B$2109)-Lookup("4020 AZ",TrialBl!$A$1:$B$2109)-Lookup("4020 CO",TrialBl!$A$1:$B$2109) The real formula is really much larger than this. What I'd like to do is be able to look in the data and return the sum of the return vector who have a "4020" in the Lookup Vector Any help greatly appreciated John KBS |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
How can you sum the last 5 columns of data from a range of data | New Users to Excel | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
Sort pages? | Excel Discussion (Misc queries) |