If Cell B = text in col C, input value from col A

[dangive]

Hello everyone,

I wanted to know if there was a formula or macro that I could use which would look up a string of text in column B:B and if found in column D:D return the value which correlates to its row, but the value i want is in column A.

Its hard to explain but i am attaching an image which hopefully explains what im saying. In this image, I want the value in column A which correlates to Column F when looked up to column C and the result placed in column E.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Column A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[/TR]
[TR]
[TD]dealer ID number[/TD]
[TD]Cars
[/TD]
[TD]Model[/TD]
[TD][/TD]
[TD]Dealer ID[/TD]
[TD]Model[/TD]
[/TR]
[TR]
[TD]4866[/TD]
[TD]honda[/TD]
[TD]a[/TD]
[TD][/TD]
[TD][/TD]
[TD]c[/TD]
[/TR]
[TR]
[TD]3558[/TD]
[TD]toyota[/TD]
[TD]b[/TD]
[TD][/TD]
[TD][/TD]
[TD]a[/TD]
[/TR]
[TR]
[TD]6482[/TD]
[TD]scion[/TD]
[TD]c[/TD]
[TD][/TD]
[TD][/TD]
[TD]b[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Hope that makes sense.

Please let me know if there's anything that can help.

Thank you

 

[jtakw]

Hi,

Is this what you mean:

Book1
	A	B	C	D	E	F
1	dealer ID number	Cars	Model		Dealer ID	Model
2	4866	honda	a		6482	c
3	3558	toyota	b		4866	a
4	6482	scion	c		3558	b
Sheet372

Cell Formulas
Range	Formula
E2	=INDEX(A$2:A$4,MATCH(F2,C$2:C$4,0))

Formula copied down.

 

[dangive]

OMG YES! THANK YOU @jtakw

 

[jtakw]

You're welcome, welcome to the forum.