Formula "IF"

[fernj]

I have the attached document. Under "Sheet1" I will enter the result in column A. I need for columb B to prefill from the corresponding cell in "Sheet2". If Result is 50, it B2 should prefill Object 50. I have a total of 180 objects listed in Sheet2.

thanks for your help.

[Palmetto]

You need to add a column on sheet2 which includes the same reference values you enter on sheet1 so that you get a cross-reference for a look up.

The use the VLOOKUP formula, similar to this:

=VLOOKUP(A3,Sheet2!$A$2:$B$180,2,FALSE)

See attached.

[fernj]

got it. Thanks a lot.