Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-09-2011, 07:35 AM
skoz55 skoz55 is offline Searching A Database Two Ways Windows 7 64bit Searching A Database Two Ways Office 2010 64bit
Novice
Searching A Database Two Ways
 
Join Date: Jan 2009
Posts: 20
skoz55 is on a distinguished road
Default 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?
Attached Files
File Type: xlsx DB Sample.xlsx (11.0 KB, 10 views)
Reply With Quote
  #2  
Old 11-09-2011, 10:14 AM
4thangel 4thangel is offline Searching A Database Two Ways Windows 7 32bit Searching A Database Two Ways Office 2010 32bit
Novice
 
Join Date: Nov 2011
Posts: 5
4thangel is on a distinguished road
Default

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
Reply With Quote
  #3  
Old 11-09-2011, 11:45 AM
skoz55 skoz55 is offline Searching A Database Two Ways Windows 7 64bit Searching A Database Two Ways Office 2010 64bit
Novice
Searching A Database Two Ways
 
Join Date: Jan 2009
Posts: 20
skoz55 is on a distinguished road
Default

Thanks 4thangel, however there was no spreadsheet attached. Could you reattach it please.
Reply With Quote
  #4  
Old 11-10-2011, 01:01 AM
4thangel 4thangel is offline Searching A Database Two Ways Windows 7 32bit Searching A Database Two Ways Office 2010 32bit
Novice
 
Join Date: Nov 2011
Posts: 5
4thangel is on a distinguished road
Default

ooops

Sorry

4thangel
Attached Files
File Type: xlsx 4thangel.xlsx (11.8 KB, 11 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Searching A Database Two Ways Searching for Word Documents jocaan Word 2 09-08-2011 11:48 AM
Searching A Database Two Ways Searching hyperlinks PuddinPie Word 1 05-27-2011 02:02 AM
Searching A Database Two Ways Backwards Searching Using a Formula OTPM Excel 5 05-17-2011 09:17 AM
Searching A Database Two Ways 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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:10 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft