#spill! error

[julee.stein]

I am doing an if then statement and am getting #spill! error. I have never gotten this.
On sheet 1 I have a list of skus and their description.
On sheet 2 if I type in a sku, I want it to bring over the description from sheet 1.

My formula is:
=if('sheet 1A:A',sheet 2a10,'sheet 1'B:B)

[bebo021999]

Try VLOOKUP

=VLOOKUP('sheet 2'!A10,'sheet 1'!A:B,2,0)