Best Answer

You just need to be able to reference the other sheet, which you do with the sheet name, an exclamation mark and a cell reference. So in a cell on Sheet2, you could have a formula referencing cell A3 on Sheet1 that could be something like:

=IF(Sheet1!A3>50, "Over 50","50 or Less")

User Avatar

Wiki User

โˆ™ 2017-06-15 08:58:38
This answer is:
User Avatar
Study guides

What was the purpose of the Dawes Act

What is Nepotism

What is one effect the Dawes Severalty Act had on Native Americans

How did railroads increase the need for time zones

See all cards
49 Reviews

Add your answer:

Earn +20 pts
Q: How do I populate cells in one Excel worksheet into another based on conditional data?
Write your answer...
Still have questions?
magnify glass
People also asked