#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
Hi,
The solution in the attached file may trigger how to solve your problem I used match and indirect function to locate the output. Note in the demand I did do a ugly modification by substracting 1 else an exact match would give aincorrect output. Hope this helps 4thangel |
#3
|
|||
|
|||
Thanks 4thangel, however there was no spreadsheet attached. Could you reattach it please.
|
#4
|
|||
|
|||
ooops
Sorry 4thangel |
|
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 |