Excel vlookup function with multiple conditions?

Question

Assuming one ID may refer to several Colors, and Versions
Let’s say if I want ID, Color, and Version matches, then return values from a table - Company
ID Colors Versions
1 Red A
2 Green B
3 Red B
2 Yellow C

ID Colors Versions Company
1 Red A Dell
2 Green B Apple
3 Red B Nokia
2 Yellow C Acer

Answer 1

In cell A2 I typed 1
In cell B2 I typed Red
In cell C2 I typed A

I then repeated this for all of the index data.
I also typed the Company data in the same way.

For this to work you must have a complex key in the company data. This can be achieved using the CONCATENATE function.
The company data must be sorted into ascending order.

Now use the following VLOOKUP function
VLOOKUP(CONCATENATE(A2,B2,C2), Put the sorted search array here, put the column number to return here)

Answer 2

Insert a column in the look-up table. This should be the first column in that table. Say you have your data in C,D,E,F columns for your four values. Then type in B1

=C1&D1&E1&F1 and copy it down

Now you can use the vlookup function to extract data
Say you have to extract a list of values and you have that table in the range (L,M,N) then type in O1 (this can be anywhere)


=Vlookup (L1&M1&N1,$B$1:$F$25,5,False)

$B$1:$F$25 is the lookup value table
5 is the 5th column of that table, in this case, "Company"
False - Exact match - you dont have to sort the table

If you have any question, email me

Answer 3

you could desire to prepare a nested IF, yet with particularly countless thoughts, it would replace into awkward and so a VLOOKUP could be better perfect. Say your numbers are in cells A2 to A12 and the corresponding text fabric fabric for each physique is in B2 to B12. Then your formulation could be like this the placement A20 is the placement you enter the fee you're searching for: =VLOOKUP( A20, A2:B12, 2 ) So in case you enter a million in A20, then you quite gets the text fabric fabric output you %..