VLookup - results 1, 2, 3 rows down

[Danno43]

Hi, I am trying to find out if there is a way to use VLOOKUP (or a similar formula) to find a value in my database, count over for result, then give me the value 1, 2 or 3 rows down. Does anyone know of way to do that? My normal VLOOKUP looks like this =VLOOKUP(A19,'[FiOS Database10.xls]YTD'!$B:$DR,7,FALSE), now I would like to add more data on more rows. Please advise.

36915 -WICKLINE Total 0 .1 .0 .00 30 63.5 100.0
NTWK/VOICE 0 .1 .0 .00 8 15.2 100.0
DATA 0 .0 .0 .00 10 19.7 100.0

[NBVC]

Try something like:

=INDEX('[FiOS Database10.xls]YTD'!$B:$DR,MATCH(A19,'[FiOS Database10.xls]YTD'!$B:$B,0)+2,7)

The +2 indicates 2 rows down from actual result...

[Danno43]

Thank you NBVC! It seems to work!

[NBVC]

Please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save