I'm attempting to duplicate data from sheet 1's column E, "Cost," so that sheet 2's column A, "Code," matches column A, "Code," on sheet 1.

```1
+--------+--------+---------------+---------+--------+
| A      | B      | C             | D       | E      |
+--------+--------+---------------+---------+--------+
| Code   | Name   | Description   | Price   | Cost   |
+--------+--------+---------------+---------+--------+
| AC33   | Prod 1 | Prod Desc 1   |  3.99   | 2.00   |
+--------+--------+---------------+---------+--------+
| AC34   | Prod 2 | Prod Desc 2   |  4.99   | 3.00   |
+--------+--------+---------------+---------+--------+
| AC35   | Prod 3 | Prod Desc 3   |  5.99   | 4.00   |
+--------+--------+---------------+---------+--------+

2

+--------+--------+---------------+---------+
| A      | B      | C             | D       |
+--------+--------+---------------+---------+
| Code   | Name   |Updated Price  | Cost    |
+--------+--------+---------------+---------+
| AC33   | Prod 1 |    16.99      |         |
+--------+--------+---------------+---------+
| AC37   | Prod 2 |    18.99      |         |
+--------+--------+---------------+---------+
| AC38   | Prod 3 |    21.99      |         |
+--------+--------+---------------+---------+
```

I am bringing down this formula to sheet 2's column D.

=VLOOKUP(A2,'1'!\$A\$2:\$A\$811,5)

Dec 12, 2022 in Others 390 views

## 1 answer to this question.

Try this:

`=VLOOKUP(A2,'1'!\$A\$2:\$E\$811,5,0)`

I altered "1"! \$A\$2:\$A\$811 to '1'! The table range you're using VLOOKUP on should contain both the column containing the lookup value and the column containing the result you desire to extract. \$A\$2:\$E\$811 In addition, I told VLOOKUP to use its last input, 0, to search for precise matches.

UPD:

As follows up from comments, the next formula works for OP:

`=VLOOKUP(TRIM(A2),'1'!\$A\$2:\$E\$811,5,0)`
• 63,420 points

## How to compare two excel sheets

How to compare two excel sheets , ...READ MORE

## Excel - count days between two dates per year

Put this in C2 and copy over: =MIN(DATE(C1,12,31),\$B\$2)-MAX(DATE(C ...READ MORE

## Excel: Get text between two characters

Try this: =SUBSTITUTE(TEXTAFTER(A1:A4,"/",-1),"'","") Here is the output:  Similarly to get ...READ MORE

## Count unique matches between two rows in Excel

The formula should be (in Excel 365) =SUM(--(COUNTIF(Draws!\$B\$2:\$G\$18,B2:K2)>0)) so ...READ MORE

## Convert three letter country codes to full country names

Just create a list to be used in ...READ MORE

## Using VLOOKUP()

Vlookup takes the lookup value first, so ...READ MORE

## How to use Excel VLOOKUP function with words that begin with the letters AB

If you lookup "AB" in Excel, it ...READ MORE