Thread: vlookup
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default vlookup

.. G Column+4 rows
To extract from a row "below" what is matched,
try an index/match - it allows you to adjust the "MATCH" easily

Hence in O3, try this:
=INDEX('Financial Itininary'!G:G,MATCH(U2,'Financial Itininary'!C:C,0)+4)
which adjusts for the return from col G to be + 4 rows below the match

If you need an error trap, use an IF(ISNA .. trap on the MATCH,
indicatively like this:
=IF(ISNA(MATCH(..)),"",INDEX(..))

voila? celebrate it, hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---