|
|
#1
11-09-2011, 07:35 AM
|
|||
|
|||
Searching A Database Two Ways
I work with building code tables often and am trying to create two different formulas:
1. Given data from the left column and data from the array, output the intersection from the top row. 2. Given data from the left column and data from the top row, output the intersection of the two from the array. I've tried MATCH, VLOOKUP, INDEX, and combinations and can't seem to get it right. I've attached a spreadsheet sample of what I'm trying to do. Can anybody help me with this? 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Searching for Word Documents
|
jocaan | Word | 2 | 09-08-2011 11:48 AM |
|
Searching hyperlinks
|
PuddinPie | Word | 1 | 05-27-2011 02:02 AM |
|
Backwards Searching Using a Formula
|
OTPM | Excel | 5 | 05-17-2011 09:17 AM |
|
effective searching
|
mar999 | Office | 1 | 05-04-2011 04:51 AM |
| Creative Ways for a year-to-year comparison??? | ridonkulous5 | Excel | 1 | 03-23-2011 04:49 PM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode