CODEWITHSUNDEEP
excelindexing
BlackCat
BlackCat

Reputation: 2044

How to pull value from another sheet in excel?

I have two sheets- "Employee" and "Salary"

In Salary Sheet, in 'E3' cell I want to set value from 'S4' cell of Employee sheet.That mean whatever data in 'S4' of Employee Sheet will be set in 'E3' in Salary

I think it is simple but I am new to this.

Upvotes: 0

Views: 44

Answers (2)

Mattias Martens
Mattias Martens

Reputation: 1647

=Employee!S4

In general, it'll be the sheet name followed by ! followed by the cell lookup. If the sheet name has spaces it will need to be wrapped in single quotes.

Upvotes: 1

Maya Amiad
Maya Amiad

Reputation: 46

you can start writing the formula and when you need the cell from the other sheet just go with the mouse to the relevant sheet and choose the required cell, Excel will write the name of the path in the formula for you...

Upvotes: 1

Related Questions