Results 1 to 5 of 5

Returning values from another sheet which works when dragged horizontally and vertically

Threaded View

  1. 01-06-2015, 08:19 AM #4
    samba_ravi
    samba_ravi is offline
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,939

    Re: Returning values from another sheet which works when dragged horizontally and vertical

    =INDIRECT("'CANADA'!"&ADDRESS(24,COLUMN(B:B)))
    Use the formula like this
    see attached file
    Attached Files Attached Files
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Lookup & get returning vertically values
    By Jhon Mustofa in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-30-2014, 10:08 PM
  2. look-up values horizontally and reflect them vertically
    By Ksenia in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-30-2014, 01:52 PM
  3. Can you autofill horizontally and vertically?
    By keez1993 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-27-2014, 03:59 AM
  4. [SOLVED] LOOKUP through duplicates, but returning multple values (vertically)
    By TommyK25 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-12-2013, 07:46 AM
  5. Excel 2007 : Transposing Values w/ Duplicate Fields (Vertically Arranged) Horizontally
    By mikedemayo in forum Excel General
    Replies: 8
    Last Post: 06-19-2012, 06:02 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1