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