Database lookups

  • Thread starter Thread starter Michelle
  • Start date Start date
M

Michelle

I'm not sure how to go about doing this but here is what
I'm after:

I have a database that "ranch house numbers" are in
rows, "breeder names" are in columns and the volume of
each breeder source that went into each house is the
connection point. I'm very familiar with vlookups, so to
lookup the ranch house number and bring over one of the
volumes isn't a problem. But how do I bring over "breeder
names" (column title) and volumes per breeder name if
their are multiple for each house that I am looking up?

Hope you can help!!
Michelle
 
Don't know if I quite follow exactly what you're asking, but is this in the
right direction?

A1:D1 = labels
House Num, Breeder1, Breeder2, Breeder3

A2:A50 = numbers
B2:D50 = volumes

House number to lookup is entered in E1,
Breeder name to lookup is entered in F1,
Enter this formula in G1:

=INDEX(B2:D50,MATCH(E1,A2:A50,0),MATCH(F1,B1:D1,0))
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



I'm not sure how to go about doing this but here is what
I'm after:

I have a database that "ranch house numbers" are in
rows, "breeder names" are in columns and the volume of
each breeder source that went into each house is the
connection point. I'm very familiar with vlookups, so to
lookup the ranch house number and bring over one of the
volumes isn't a problem. But how do I bring over "breeder
names" (column title) and volumes per breeder name if
their are multiple for each house that I am looking up?

Hope you can help!!
Michelle
 
RD...
Thanks for replying to my problem. The index-match
combination would be my next step, but then I'd still need
additional steps to get to my goal. And that may be the
only way aroung this...I was hoping for a one-step do-
all. Here's some more info:

A1:J1=labels (Hs Number, Type1, Type2, thru Type9
A2:A15=house numbers
B2:J15=volume by breed type

The result I'm after would be something like this:
Hs Number Type1 Type4 Type7
4 5000 10000 6000

I know I could use filter or even pivot tables, but I will
be in a different database. So if I could go to this
database lookup by house # and pull over just the columns
that have amounts in them (not all 9 types) as a result to
keep the history of the houses and what types went into
them????
 
Where does the house number in the lookup, that initiates pulling in the
breeder type data, come from?
Will you manually enter it, looking up a particulat house, one by one?
OR
Are you looking for an *automatic* return of all existing house numbers that
might have any data in the corresponding columns under the various breeder
types?

If the second option, then you should definately try to do something with
pivot tables or use code.

--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------


RD...
Thanks for replying to my problem. The index-match
combination would be my next step, but then I'd still need
additional steps to get to my goal. And that may be the
only way aroung this...I was hoping for a one-step do-
all. Here's some more info:

A1:J1=labels (Hs Number, Type1, Type2, thru Type9
A2:A15=house numbers
B2:J15=volume by breed type

The result I'm after would be something like this:
Hs Number Type1 Type4 Type7
4 5000 10000 6000

I know I could use filter or even pivot tables, but I will
be in a different database. So if I could go to this
database lookup by house # and pull over just the columns
that have amounts in them (not all 9 types) as a result to
keep the history of the houses and what types went into
them????
 
Back
Top