MobileMobile | Continue

Excel Bar

Excel Bar

Your excel questions will be responsed by our excel experts within 24hrs.Our service is free.

 Forgot Pass?
 Register Now
Find
Hot Search: Vlookup Match VBA
12
Return Post new threads
Author: Aland2929

Display a named range of cells each time a selection from a

[Copy link]

15

Topics

80

Posts

197

Integral

Conqueror

Rank: 3Rank: 3

Integral
197
 Author| Post on 2-12-2017 00:50:16 | All posts



one way is to use the INDEX function.
You will need 1 cell with a Match function to locate top left corner of company data.








  • 1173503.xlsx
    (13.5 KB, 22 views)
    Download















  • Reply Support Opposition

    Props Report

    15

    Topics

    80

    Posts

    197

    Integral

    Conqueror

    Rank: 3Rank: 3

    Integral
    197
     Author| Post on 2-12-2017 02:39:36 | All posts



    one way is to use the INDEX function.
    You will need 1 cell with a Match function to locate top left corner of company data.








  • 1173503.xlsx
    (13.5 KB, 24 views)
    Download















  • Reply Support Opposition

    Props Report

    12
    Return Post new threads

    Points policy of this forum

    Archiver|Mobile|Small dark house|Contact us|Excel Bar

    GMT-5, 9-25-2017 15:42 , Processed in 0.338978 second(s), 17 queries .

    Powered by Discuz! X3

    © 2001-2013 Comsenz Inc.

    !fastreply! Top !return_list!