Conditional Table Array for Vlookup?

Jiri

New Member
Joined
Apr 16, 2020
Messages
1
Office Version
2019
Platform
MacOS
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? :)
 

Attachments

Some videos you may like

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Dave87

Board Regular
Joined
Apr 22, 2020
Messages
69
Office Version
365, 2019, 2016
Platform
Windows
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
 

Watch MrExcel Video

Forum statistics

Threads
1,099,143
Messages
5,466,931
Members
406,511
Latest member
markflayd

This Week's Hot Topics

Top