Results 1 to 6 of 6
  1. #1
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    Surrey, United Kingdom
    Posts
    1,001
    Thanks
    0
    Thanked 0 Times in 0 Posts

    INDIRECT (2003 SP2)

    Good morning

    I am using the INDERECT function to pull some address details through to a form, =INDIRECT("AddressList!P"&$E$8) can I change this so that on the form it would always say Subject: and then the INDERECT result, for example, in the Address List column P I was to type Meeting in room 401 15:30 Monday the receiving cell on the form would show Subject: Meeting in room 401 15:30 Monday

    Cheers

    Steve
    Cheers

    Steve

    Asking the questions everbody wants the answers too but feels too stupid to ask themselves :-)

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: INDIRECT (2003 SP2)

    Like this perhaps:
    ="Subject: "&INDIRECT("AddressList!P"&$E$8)

    Steve

  3. #3
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    Surrey, United Kingdom
    Posts
    1,001
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: INDIRECT (2003 SP2)

    Thanks Steve

    Like me it was very simple <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    Cheers as usual

    Steve
    Cheers

    Steve

    Asking the questions everbody wants the answers too but feels too stupid to ask themselves :-)

  4. #4
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    Surrey, United Kingdom
    Posts
    1,001
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: INDIRECT (2003 SP2)

    Sorry Steve

    Another couple of questions on the INDIRECT subject if you do't mind,

    1) if in one cell I want to show the results of 2 cells B and A how would I word the formula, for example I have =INDIRECT("AddressList!B"&$E$8) but would like the receiving cell to show the contents of B and A and have tried B,A B:A and ("AddressList!B","AddressList!A" but can't seem to figure it out

    2) If (1) above is possible could I then have a permanent word show before the INDIRECT call for column A - for example if B says University Hospital and A says 102335 could the INDIRECT formula then show as University Hospital Site 102335
    3) If both (1) and (2) can be achieved can the second part (Site 102335) be made to be bold although the first part (University Hospital) is plain, for example University Hospital Site 102335

    cheers

    Steve
    Cheers

    Steve

    Asking the questions everbody wants the answers too but feels too stupid to ask themselves :-)

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: INDIRECT (2003 SP2)

    1) If you want to concatenate the values of two cells:

    =INDIRECT("AddressList!B"&$E$8)&INDIRECT("AddressL ist!A"&$E$8)

    2) Concatenation again:

    =INDIRECT("AddressList!B"&$E$8)&" Site "&INDIRECT("AddressList!A"&$E$8)

    3) You can't format part of a formula result. It'd be better to put the two parts in two adjacent cells, and make the second cell bold.

  6. #6
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    Surrey, United Kingdom
    Posts
    1,001
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: INDIRECT (2003 SP2)

    Thanks very much Hans

    Cheers

    Steve
    Cheers

    Steve

    Asking the questions everbody wants the answers too but feels too stupid to ask themselves :-)

Posting Permissions

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