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.

Column A	B	C	D	E	F
dealer ID number	Cars	Model		Dealer ID	Model
4866	honda	a			c
3558	toyota	b			a
6482	scion	c			b

<tbody>
</tbody>

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.