| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup and return values using lists
I have two enormous spreadsheets that rely on eachother for accuracy. The
first spreadsheet has street names and city sections with appropriate funding sources the second sheet has unique tickets using the city street name and section but does not have the funding source (and alot of other data)...how can I compare the two sheets to get the funding source into the second spreadsheet? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
lookup and return values using lists
Take a look at SUMPRODUCT
http://www.xldynamic.com/source/xld.SUMPRODUCT.html "bundes73" wrote: I have two enormous spreadsheets that rely on eachother for accuracy. The first spreadsheet has street names and city sections with appropriate funding sources the second sheet has unique tickets using the city street name and section but does not have the funding source (and alot of other data)...how can I compare the two sheets to get the funding source into the second spreadsheet? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
lookup and return values using lists
The value I need returned is by comparing two street names and returning a
funding class name - nothing numerical. This is from two separate workbooks. Lost in a mountain of data :-) "lk" wrote: Take a look at SUMPRODUCT http://www.xldynamic.com/source/xld.SUMPRODUCT.html "bundes73" wrote: I have two enormous spreadsheets that rely on eachother for accuracy. The first spreadsheet has street names and city sections with appropriate funding sources the second sheet has unique tickets using the city street name and section but does not have the funding source (and alot of other data)...how can I compare the two sheets to get the funding source into the second spreadsheet? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LOOKUP 2 DIFFERENT VALUES AT ONE TIME AND RETURN A VALUE | Excel Worksheet Functions | |||
| Lookup in Multiple Columns, Return Multiple Values | Excel Worksheet Functions | |||
| Lookup mulitple values and return one | Excel Worksheet Functions | |||
| lookup mutliple values to return one value | Excel Worksheet Functions | |||
| Lookup values in one column to return another | Excel Worksheet Functions | |||
Linear Mode
