Multiple Database Lookup

[kelvinluc]

Hi All,

I have a problem whereby i need to see if a worksheet exists, if it
does, pick out specific data from that sheet based on the criteria i
select. Our industry is Furniture Frame Making so the example below
is biased to that.

I need to pick a certain model from a drop down list, let's say it's
name is "Ditto", another drop down box will select frame type, "3
Seater".

A cell looking up the relative path to a ditto worksheet exists, but
there may be several ditto sheets, but only one will contain a 3
seater model.

I then need to be able to look through several worksheets to look for
the relevant information.

I have a sheet at the rear of the workbook, with names and relative
paths to the worksheets so these will never change. I have gone down
this road so far .....

If "workbook5" exists, look through that in a specific cell reference
that matches "3 seater", if not then go onto the next "workbook4", etc
etc until finally it looks at the first workbook.

I don't have a problem with the IF, AND, OR formulas but the way in
which i have put the full path together to grab the data i require is
driving me mad. ie. Changing a concatenated text string that makes
up a formula to a lookup or get data formula. Can send example if
someone can help.

Basically, i cannot figure out how to change the concatenated string
into a proper function to grab the data i need.

I 've been stuck on this for a few hours now. It's doing my heeeed
in.

Thanks in advance to anyone who can help.

regards

Kelv

 

[Earl Kiosterud]

Kelvin,

Spreading your data across sheets makes data retrievel difficult. Take a look at Data
across multiple sheets at http://www.smokeylake.com/excel/excel_truths.htm. It will be well
worth your while.

 

[kelvinluc]

Kelvin,

Spreading your data across sheets makes data retrievel difficult. Take a look at Data
across multiple sheets athttp://www.smokeylake.com/excel/excel_truths.htm. It will be well
worth your while.
--
Regards from Virginia Beach,

Earl Kiosterudwww.smokeylake.com
















- Show quoted text -

Thanks Earl, you clarified what i thought.

The sheets i'm grabbing data from are already huge spreadsheets
themselves.

I think i'll just have have to get ALL the data from ALL the sheets in
my list(s) and sort the selective data i need using "if" statements
for each range.

Thanks again.