|You've used the words value tab a number of times. I'm not sure what you meant by that so I'll assume you mean a cell.|
If that's correct, then VLOOKUP will work, but you have to finesse it a little since you will be using different table_arrays based on which category you have chosen.
Remember that VLOOKUP has the following syntax:
VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)
Let's go back to the named ranges you used for the dependant drop down lists.
You have a range named Furniture which looks like this:
In the column next to that list place the values:
Select these cells and name the range
Now let's say your first drop down is in B1 and currently shows Furniture
Your dependant drop down in C1 might show chairs
Try this VLOOKUP construction:
which, in this example, evaluates to:
Which should return 100
What you are doing is using the text in B1 (your category) to build the range name within the VLOOKUP function so that the table_array changes depending on which category you have chosen.
To deal with the warranty issues and #N/A errors, you can wrap some IF statements around the VLOOKUP to get it to do what you want.