0 votes

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 tried using a VLOOKUP, but it's not working. Please help. Am I using Vlookup correctly?

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 481 views

## 1 answer to this question.

0 votes

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)`
answered Dec 13, 2022 by
• 63,700 points

0 votes
0 answers

## How to compare two excel sheets

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

0 votes
1 answer

## 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

0 votes
1 answer

## Excel: Get text between two characters

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

0 votes
1 answer

## 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

0 votes
1 answer

## Convert three letter country codes to full country names

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

0 votes
1 answer

## How to categorize/classify numbers from different ranges using Excel?

I wouldn't advise utilizing nested IFs because ...READ MORE

0 votes
1 answer

## Using VLOOKUP()

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

0 votes
1 answer

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

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

0 votes
1 answer

## Using Excel VLOOKUP() function across two sheets

The syntax for VLOOKUP is VLOOKUP(Lookup_Value,Table Array,Col_index_num,Range_lookup) OR, to start in ...READ MORE

0 votes
1 answer

## Excel: How to merge two columns into one (from different sheets or separated columns)

This equation is completely adjustable. Your two ...READ MORE