finding data from tables using MATCH dependant on cell value.

Hi Guys.

I need a bit of help with finding data from a table dependant on what is selected in a Cell.
Example, I want the following to run on a table which is determined by said cell value.

Please Login or Register  to view this content.

Cell C4 will determine which sheet the table will be on, then the above code needs to work for that sheet.

My options for C4 will be:
Fusion,
Fusion Linear,
Biography,
Caledonia,
Caledonia In-Frame

I will have individual sheets which will have large data tables named for each.

So, if Cell C4 has "Fusion Linear" selected, The data needs to be found from that table.

Originally Posted by joris moerings

Hi,

Change your formula to this

Formula:

Please Login or Register  to view this content.

Hope this helps.

Thank you, this does work in essence - However, cell C4 relies on DV lists which have the same names as the tables, which I have discovered is throwing out the options given in Cell C5, which then gives me my pricing.

I need Cell

My quotation tool uses a cell selection process to determine product ranges and pricing, as follows:
Cell C4 - Select the primary range from DV list "Ranges" (Fusion, Fusion linear, Biography, Caledonia, Caledonia In Frame)
Then
Cell C5 - Select The specific door range from a DV list determined by selection of C4

Please Login or Register  to view this content.

DV list names are the same as the Range sheets and Range Tables
Then
Cell C3 - shows a price group dependant upon selection from C5, eg "PG01" (Which are in the table headers and the 1st part of the cell data in the 'Range' DV List

Please Login or Register  to view this content.

Then
User to enter product code into cell B13 and Cell M13 is To return a price from the relevant table in selection of C4 for that product in that price group for that product range.

Basically, I have 5 kitchen ranges, which all have the same product codes but different prices between the ranges - Ie, BFH3 might be £70 in Price group1 in Fusion, yet BFH3 might be £150 in price group1 in Caledonia.

does that make any sense at all?.. Bit confusing.

Originally Posted by joris moerings

Hi,

Indeed a bit confusing. Perhaps posting a sample ...

Okay, thanks for your response. So, it took me a little while to make a small version of what I'm doing. It's a huge document in total, so I've scaled it down massively just to demonstrate the sections I need a bit of help with.
The biggest problem I am having is that I need a DV list, and tables with the same names in order to be able to select data correctly... If you click on the red comment tabs you should see what I mean.

Does the file need to be macro-enabled? Some of us won't open macro-enabled files.

Originally Posted by AliGW

Does the file need to be macro-enabled? Some of us won't open macro-enabled files.

Not this one, no - My main doc does use Macro's, but there aren't any on this one.

I've attached it without - in case it makes a difference to you.

Originally Posted by RichardJSigKits

Not this one, no - My main doc does use Macro's, but there aren't any on this one.

Thanks - the "m" in the suffix doesn't tell me that there is none in the file, rather suggests otherwise! I'll have a look at the new version you've posted.

Originally Posted by AliGW

Thanks - the "m" in the suffix doesn't tell me that there is none in the file, rather suggests otherwise! I'll have a look at the new version you've posted.

Any joy on this at all please?