Hi
I am trying to work out this problem with a function.

if a cell AA2 has data in it the function should return the data the A2 has in it. If AA2 is blank the whole line should be ignored.
If cell AA2 has data in it return the value of A2.
If Cell AA2 has value but cell A2 is blank return a value of 999

What I have so far,
=IF(Results!AA2=0,"",Results!A7)

That works but I'm really stuck on the rest.

S