Hi there,

As teylyn has advised...

=CHOOSE(B24,"apples","bananas","oranges")

if B24 = 1, then the result will be "apples", if B24 = 2, the result will be "bananas", etc.
Another option could be rather than relying on the user typing numbers to get the outcome "example typing 1 would display apples", you could create a combo box (multiple combo boxes if needed) on sheet1.

Then on a second sheet use the choose formula to pull the selected data from the combo box so it appears in a table etc on sheet 2.

Thanks