Return value adjacent based on match

[cms90740]

Hi all,

I believe I've done something similar to my current problem but I can't quite figure this one out. Would appreciate any advice!

I'm trying to match 2 values in different columns and then return the adjacent value from a third column. Hopefully this demonstrates it clearly.

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]title[/TD]
[TD]value[/TD]
[TD]titles[/TD]
[TD]value[/TD]
[/TR]
[TR]
[TD]green[/TD]
[TD][/TD]
[TD]green[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]orange[/TD]
[TD][/TD]
[TD]blue[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]green[/TD]
[TD][/TD]
[TD]red[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]red[/TD]
[TD][/TD]
[TD]orange[/TD]
[TD]4[/TD]
[/TR]
</tbody>[/TABLE]


I'd like to create a formula for column B that matches column A against column C and returns the corresponding value in column D. For instance, B2 would equal 1, B3 would equal 4, B4 would equal 1, and B5 would equal 3. Hope that makes sense. Thanks in advance for your help!

 

[AhoyNC]

Assuming no dup;icates in column C try VLOOKUP.

Excel Workbook
	A	B	C	D
1	title	value	titles	value
2	green	1	green	1
3	orange	4	blue	2
4	green	1	red	3
5	red	3	orange	4
Sheet

 

[cms90740]

Assuming no dup;icates in column C try VLOOKUP.

	A	B	C	D
green	green
orange	blue
green	red
red	orange

<colgroup><col style="width:30px; "><col style="width:67px;"><col style="width:66px;"><col style="width:71px;"><col style="width:76px;"></colgroup><tbody>
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]1[/TD]
[TD="bgcolor: #c0c0c0"]title[/TD]
[TD="bgcolor: #c0c0c0"]value[/TD]
[TD="bgcolor: #c0c0c0"]titles[/TD]
[TD="bgcolor: #c0c0c0"]value[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]2[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: center"]1[/TD]

[TD="align: right"]1[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]3[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: center"]4[/TD]

[TD="align: right"]2[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]4[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: center"]1[/TD]

[TD="align: right"]3[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]5[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: center"]3[/TD]

[TD="align: right"]4[/TD]

</tbody>

Spreadsheet Formulas

Cell Formula B2 =VLOOKUP(A2,$C$2:$D$5,2,0) <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

This worked perfectly, thank you!

 

[AhoyNC]

You're welcome. Thanks for the feedback.