Using two criteria to show the correct result - Help!!

[OLLY-7]

Hi Guys,

I have fairly basic Excel knowledge but trying to make a fairly complicated spread sheet - of which this is my fist sticking problem:

I am setting up a quotation template for a range of furniture. Have set up a Data Validation drop down list to select the item of furniture and then linked a vlookup to this to fill in associated info such as size and drawing number. I also have some stand-alone data validation drop down lists for wood finish and metal finish and fabric spec.

Problem: now I come to the fabric or hide qty column which will depend on the item of furniture selected + whether it is in a leather or fabric. At a loss as to how best to approach this or do it.

Any help would be fantastic.

Many thanks.
Filter Problem.xlsx

[Spencer101]

Hi, try the below formula in cell M4 and copy down.

=IFERROR(INDEX('JOB - FABRIC'!$B$4:$U$11,MATCH('MASTER QUOTATION'!L4,'JOB - FABRIC'!$A$4:A$11,0),MATCH('MASTER QUOTATION'!E4,'JOB - FABRIC'!$B$3:$U$3,0)),"")

[Richard Buttrey]

Hi,

Please Login or Register  to view this content.

[OLLY-7]

Both work a treat. Thank you very much indeed!