I have a table similar to this, to which I want to add a new "DESC" column:

First row_1
Second row_2

On the other hand, I have a table, called dictionary with the description:

Code DESC
row_1 Description1
row_2 Description2

What formula can I use in Excel to get the value of the DESC row when the code matches?And let it stay like this:

First row_1 Description1
Second row_2 Description2
Jan 12, 2023 in Others 479 views

## 1 answer to this question.

Use VLOOKUP, to make sure that your "Another header" ("Code") is unique.

Formula in C6 (and dragged down) is =VLOOKUP(B6,A2:B3,2,FALSE)

Result:

• 63,720 points

## Calculate the number of days between a cell and today in excel?

Use the DATEDIF function when you want ...READ MORE

## Excel - How can I get the average of cells where the value in one column is X and the value in another column is Y?

Use AVERAGEIFS ... =AVERAGEIFS(C2:C13,A2:A13,"Yellow Typ ...READ MORE

## Get random value in the range of plus/minus 10% of a cell value in Excel

Why not just use RANDBETWEEN(B2*0.9, B2*1.1) if ...READ MORE

## Select a range in Excel based on the value of a cell

Try this: Dim WorkRng As Range Set WorkRng = ...READ MORE

## Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

## Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

## IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE