Suppose in sheet1 :: mango in A1, egg in B1, fish in C1. All these in row 1

Now in sheet2 ::: D5 contain formula =sheet1!A1, A7 contain formula =sheet1!C1, E4 contain formula =sheet1!B1

Now in shhet2 ::: which formula i need to write in cell suppose at G5 to get everything just by writting row no of sheet1.

If put 1 then surely get mango, egg, fish

If put 2 then nothing since in sheet1 there is nothing in row2

(I have done exact thing earlier, but unfortunately there is no backup of my file. So humble request to you pls help)

By: Shan