I need a littel help with a forumla
depending on what number i inputt on sheet 1 slot A1
i want it to read the line in sheet2 posions GX wher x is the number i input at sheet1
I was thinking somthing like this, but it dosent work. hoping sombody out ther knows a easy way to do this =Sheet2!$G(Sheet1!$A$1)
2nd. question can i use the same code for both text and numbers.
depending on what number i inputt on sheet 1 slot A1
i want it to read the line in sheet2 posions GX wher x is the number i input at sheet1
I was thinking somthing like this, but it dosent work. hoping sombody out ther knows a easy way to do this =Sheet2!$G(Sheet1!$A$1)
2nd. question can i use the same code for both text and numbers.