Posted to microsoft.public.excel.misc
|
|
vlookup
Thank you max,
and Francis
"Max" wrote:
.. 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
---
|