Cross sheet IF formula
I am getting Unparseable error for this formula:
=IF({Reference sheet 1} >= {Reference sheet 2} "Yes", "No").
I am trying to determine if number in sheet 1 is greater than sheet 2 in a particular column, then input yes in the 3rd sheet and vice versa.
Is it possible to use IF formula across sheets? If so, what am I missing? Thank you!
Answers

You need to specify what in each sheet you are wanting to reference. {Reference sheet 1} will point to the entire column in that sheet. Is there a specific cell in that column you are looking at?

Thanks for the reply! I want it to be the same cell within column in each sheet. How do I specify this?

So you essentially have a column of numbers in Sheet 1 and a column of numbers in Sheet 2, and then want to compare them rowbyrow between those two sheets?
If that is the case, you need a way to identify each row in order to compare them in each of the three sheets. Something like an ID row in each sheet, numbered sequentially. You would then match the "ID" row between the sheets in order to retrieve the values you are looking for to compare.
Help Article Resources
Categories
Check out the Formula Handbook template!