Help regarding excel formula

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

Leave a Reply

Your email address will not be published. Required fields are marked *