Hello,
I am trying to vlookup a value for a competitor product based on 3 criteria (that determine product group and its exact specifications).
I was hoping I could use some logical function, that would then somehow choose(locate) and use a desired table array from which to look up the data...
Data where I want to import is sorted in rows.
Data from which I want to look up value, is sorted in column for a reason.
Therefore, when the product change, I must change "manually" change the table array.
=VLOOKUP(D30,'Competitor RAW'!B:C,2,FALSE)
=VLOOKUP(D31,'Competitor RAW'!E:F,2,FALSE)
Any ideas on how to tackle this one?
I am trying to vlookup a value for a competitor product based on 3 criteria (that determine product group and its exact specifications).
I was hoping I could use some logical function, that would then somehow choose(locate) and use a desired table array from which to look up the data...
Data where I want to import is sorted in rows.
Data from which I want to look up value, is sorted in column for a reason.
Therefore, when the product change, I must change "manually" change the table array.
=VLOOKUP(D30,'Competitor RAW'!B:C,2,FALSE)
=VLOOKUP(D31,'Competitor RAW'!E:F,2,FALSE)
Any ideas on how to tackle this one?
