Vlookup returns line number

M

MrDan8

Hi,

I have a function that returns the number of the line in a Sheet.
I need to go to another Sheet and look in Collum "B" the value of th
line that the Vlookup function number return.

How do I make a formula to see the value of the Cell?

Thanks
 
D

Dave Peterson

One way:
=index(sheet2!b:b,sheet!a1)

Another way:
=indirect("B" & sheet1!a1)

Where sheet1!a1 held a number.
 
Top