answersLogoWhite

0


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
4.12
โ˜†โ˜…โ˜†โ˜…โ˜†โ˜…โ˜†โ˜…โ˜†โ˜…
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...
Submit
Still have questions?
magnify glass
imp
People also asked