# IF value is same in two columns then display a third value from another column

#### Rick187

##### New Member
Hi,

Does anyone know which formula can achieve this:

If value in column A is the same as value in column B, then display the value from Column C

For example if Column A contains these values

C1 - AAA
C2 - BBB

Column B contains the same:
B1 - AAA
B2 - BBB
B3 - CCC

Column C contains
C1 - London
C2 - New York
Etc.

In Column D, I would like it to insert the value from Column C, so next to "AAA", I would like it to display "London"

Any help would be appreciated.

### Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

#### Tim_Excel_

##### Well-known Member
Code:
``=IF(A1=B1,C1,"")``
This is the simplest of formulas... Maybe consider googling the problem before opening a new thread?

#### Rick187

##### New Member
Unfortunately this doesn't seem to work when the columns are in different sheets.

I've tried this: =IF('Sheet1'!A:A=Sheet2!G:G,Sheet2!I:I,"")

#### Tim_Excel_

##### Well-known Member
Again, Google is your best friend... (although one could argue it isn't because of privacy reasons, but that's another topic)

Code:
``[COLOR=#333333] =IF([/COLOR]Sheet1![COLOR=#333333]A:A=Sheet2!G:G,Sheet2!I:I,"")[/COLOR]``

#### Rick187

##### New Member
Again, Google is your best friend... (although one could argue it isn't because of privacy reasons, but that's another topic)

Code:
``[COLOR=#333333] =IF([/COLOR]Sheet1![COLOR=#333333]A:A=Sheet2!G:G,Sheet2!I:I,"")[/COLOR]``
This doesn't seem to work. Nothing displays when I use this formula.

#### Tim_Excel_

##### Well-known Member
It does work on my end when I use regular text and number values. I'm assuming there's some information missing here. What do these ranges contain?

#### Rick187

##### New Member
It does work on my end when I use regular text and number values. I'm assuming there's some information missing here. What do these ranges contain?
They contain text.

In Sheet 1 If the value from A2 is contained in a range from another sheet (Sheet 2 Column G), then Display the corresponding Value from (Sheet 2 Column I)

So if I have the word "Cat" in the the first sheet in Cell A2, and in sheet 2 Column G I have 30 different words and one of them is "Cat", Next to the word "Cat" in "Column I" It says "London". I would like the word "London" to display in Sheet 1 cell B2.

seen post#7

Last edited:

#### Tim_Excel_

##### Well-known Member

For this you will have to use the MATCH function. This will return the row number of the found value, or #N/A if the value was not found. You can then return the value of the cell next to it. Use the IFNA function to handle values that won't be found.

#### jtakw

##### Well-known Member
Hi,

Change "No Match" to "" (Blank) or whatever you like, formula copied down:

1,101,754
Messages
5,482,694
Members
407,358
Latest member
Maze123

### This Week's Hot Topics

• Finding issue in If elseif else with For each Loop
Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
• MsgBox Error
Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
• CELL FORMAT - IF CONDITION
My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
• Show numbers nearly the same
Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...