Breaking News: Grepper is joining You.com. Read the official announcement!

excel set value from another sheet where column equals

vickzkater answered on July 16, 2023 Popularity 3/10 Helpfulness 1/10

answer excel set value from another sheet where column equals

excel set value from another sheet where column equals

Comment

1. Click in the cell where you want the pulled data to appear.

2. Type =VLOOKUP( then click on the cell to the left.
This will be the reference that the VLOOKUP function will look for.

3. Type a comma, and then click on the sheet that you want to pull 
data from. Click and drag over the two columns that hold your data.

4. Type another comma, and then type the number of the column that 
contains the data you want to pull across. In this case, it’s the second
column, so we would type 2.

5. Type another comma, then FALSE, then a final closed bracket to 
complete your formula. This ensures that the function looks for an exact 
match for your reference.

6. Press Enter. Your data will now appear in your cell.
7. If you want to pull across more values, select the cell and click and 
hold on the small square in the bottom right-hand corner of the cell.

8. Drag down to fill the remaining cells.

9. Now if you sort the original data, your pulled data will not change, 
since it is always looking for the data associated with each individual 
name.

Note that for this method to work, the unique identifiers (in this case, 
the names) must be in the first column of the range that you select.
And if you can't use comma, please use semicolon (;)

I quoted from https://www.groovypost.com/howto/pull-data-from-another-sheet-in-excel/
please check it coz there are images for the steps.

Popularity 3/10 Helpfulness 1/10 Language whatever

Source: www.groovypost.com

Tags: equals excel set whatever where

Link to this answer
Share Copy Link

Contributed on Jul 16 2023

vickzkater

0 Answers Avg Quality 2/10

excel set value from another sheet where column equals

Contents

More Related Answers

excel set value from another sheet where column equals

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.