Conditional Table Array for Vlookup?

[Jiri]

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?

 

[Dave87]

Its difficult to know what you are talking about when you dont show the headings, & column and row references in the screenshots or the information you are trying to return

but try using index match