Row Numbers - Take 2

[chkote]

Sorry Folks..having a mental blank on this one.
I determine a row number from my first vlookup, now how do I use that as my start row for my next lookup?
as in @VLOOKUP($A("ROW RESULT&quot,2,FALSE)
Thanks again.

 

[chkote]

Make that ........
...as in @VLOOKUP($A$("ROW RESULT&quot:$E$1000,2,FALSE

 

[ETID]

You Got a small example of the lookup table?

 

[chkote]

Table goes something like this..

Sheet1
A B C
1 CITY1 HOUSES @ROW()
2 CITY2 FACTORY @ROW()
3 CITY1 RAILWAY @ROW()

Sheet2
A B
1 CITY1
2 @VLOOKUP(Sheet2!$A$1,Sheet1!$A$1:$C$3,2,FALSE) 1
3 ???

The "C" Column in Sheet1 would result in 1,2,3 respectively
The "B" Column in Sheet2 is the result of
@VLOOKUP(Sheet2!$A$1,Sheet1!$A$1:$C$3,3,FALSE)

It's the ???? that I'm trying to figure out.....using the result in Sheet2!B2 in the next lookup as follows :
@VLOOKUP(Sheet2!$A$1,Sheet1!$A$(xxx):$C$3,2,FALSE

Where the "(xxx)" = Sheet2!B2

Thanks

 

[chkote]

Wrong again....last line should read..

@VLOOKUP(Sheet2!$A$1,Sheet1!$A$(xxx):$C$2,2,FALSE

..sorry