# Return value adjacent based on match

#### cms90740

##### New Member
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.

 title value titles value green green 1 orange blue 2 green red 3 red orange 4

<tbody>
</tbody>

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!

Last edited:

#### AhoyNC

##### Well-known Member
Assuming no dup;icates in column C try VLOOKUP.
Excel Workbook
ABCD
1titlevaluetitlesvalue
2greengreen1
3orange4blue2
4green1red3
5red3orange4
Sheet

#### cms90740

##### New Member
Assuming no dup;icates in column C try VLOOKUP.

 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

<colgroup><col style="width:30px; "><col style="width:67px;"><col style="width:66px;"><col style="width:71px;"><col style="width:76px;"></colgroup><tbody>
</tbody>

 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

##### Well-known Member
You're welcome. Thanks for the feedback.

1,082,298
Messages
5,364,377
Members
400,795
Latest member
Vercas

### This Week's Hot Topics

• populate from drop list with multiple tables
Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
• Find list of words from sheet2 in sheet1 before a comma and extract text vba
Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
• Dynamic Formula entry - VBA code sought
Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...