Cross sheet IF formula

nerowonder

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!

Carson Penticuff

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?

nerowonder

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

Carson Penticuff

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 row-by-row 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.