Matching cells from a column and returning value from a third column.

[NicolaiK]

Hello all,

I am having difficulties with matching information from two columns and returning information from a third column.

Example:

Column A has 50 rows each with a value
Column B has 30 Rows each with a corresponding value
Column C has 30 Rows each with a value

I need a formula that match A and B and when they match, return me the value from C

I am currently trying to make this IF formula work: =IF(A1=B1:B30,C1:C30,0)

Anyone have a solution for me?

Thanks for helping out!

 

[FDibbins]

See if what I posted here will help you?
https://www.mrexcel.com/forum/excel-questions/1029793-vlookupifs-vlookup-multiple-conditions.html

 

[NicolaiK]

Thank you for trying to help FDibbins! But I cant get the solution you sent to work for me... could you try to explain the J2=INDEX(A$2:A$6,MATCH($H$1&$H$2&$H$3,INDEX($A$2:$A$6&$D$2:$D$6&$B$2:$B$6,0),0)) formula using my problem?

Is this correct?

=INDEX(A1:A50,MATCH(A1,INDEX(B1:B30),0)0)

I dont think I understand what the different parts of the formula does, and so the formula might work if I input the data correctly?

 

[FDibbins]

You have 2 criteria you want to match - A and B, and if they match, you want to return C. Where do you want the results shown, and where will the criteria be that you want to match against?

 

[NicolaiK]

Yes thats correct.
The result can be shown in D1.

The criteria is A1, so if B1=A1 return C1 in D1

 

[NicolaiK]

correction: B1 meaning any of the values between B1:B30 matching A1

 

[FDibbins]

So then maybe something like this?

	A​	B​	C​	D​
1​	10​	10​	a	a
2​	20​	12​	b
3​	30​	14​	c
4​	40​	16​	d
5​	50​	18​	e
6​	60​	20​	f	b
7​	70​	22​	g
8​	80​	24​	h
9​	90​
10​	100​

D1=IFERROR(INDEX($C$1:$C$8,MATCH(B1,$A$1:$A$10,0)),"")
copied down

 

[NicolaiK]

This worked Perfectly as far as I can see right now! Thank you so much!!

 

[FDibbins]

Happy to help