vlookup

[Ralter649]

I am trying to use VLOOKUP but I want to use the row number as the lookup value. The lookup value is Sheet2 H1 and the VLOOKUP is Sheet2 G2. So far I have =VLOOKUP(H1,Sheet1!A1:J100,Sheet1!B:B,Fasle) but I need the table array to be (row number and A1:J100)

Thanks for any help you can give.

 

[offthelip]

Your question is not very clear and nor is your code but this might help:

=VLOOKUP(H1&ROW(),M$1:O$6,2,FALSE)