Excel VBA : Multiple lookup values -

i have 2 sheets. result needed in sheet1 required results column depicted below. results populated checking values in sheet2.

noun      modifier  required results                        name1   value1  name2   value2  name3   value3  name4      value4      name4    value4 abrasive    belt    abrasive belt : 5in x 2in               type    wafer   width           length  5in     thickness   2in       diameter   2m abrasive    belt    abrasive belt : 11in x 6in x 3m         type    lugged  width   11in    length  6in     thickness   3in       diameter   3m abrasive    belt    abrasive belt : 12in x 7in x 3m         type    lugged  width   12in    length  7in     thickness   3in       diameter   4m 

---

sheet2

noun      modifier  attribute name    fill abrasive    belt    type                0 abrasive    belt    width               1 abrasive    belt    length              2 abrasive    belt    thickness           3 abrasive    belt    diameter            0 abrasive    rod     type                0 abrasive    rod     length              1 

i explain update process taking first row example.

• abrasive word sheet1 searched in sheet2 noun column.
• if matches corresponding next value belt sheet1 searched in sheet2 modifier column.
• if both values matches column name1 value type should searched in sheet2 attribute name column. if fill column 0 corresponding row, no need populate value in sheet1. here in sheet 2 width, length, thickness values 1 in fill column. therefore have concatenated width, length, thichness values 5in x 2 in. in first row width blank.

so referring sheet two, need populate dimensions. have around 10k records in sheet1 , 20k reference data in sheet2. tried applying several vlookup formulas, not achieve it. please help.

one simple way make unique identifier using several identifiers add first column both of sheets containing formula:

="identifier-1"&"identifier-2"&...&"identifier-n"

where "identifier-1", "identifier-2" , "identifier-n" cell addresses containing respective identifiers.

using vlookup formula unique identifiers, desired data can retrieved.

after populating data in sheet1 value1 through value4, data can joined in dimension column using concatenate function or "&" merging values.