Results 1 to 26 of 26

if A3 has a number in, show A1 details in Z1

Threaded View

petelomax if A3 has a number in, show... 08-06-2012, 04:58 AM
oeldere Re: if A3 has a number in,... 08-06-2012, 05:05 AM
mmmarks Re: if A3 has a number in,... 08-06-2012, 05:06 AM
Ace_XL Re: if A3 has a number in,... 08-06-2012, 05:33 AM
petelomax Re: if A3 has a number in,... 08-06-2012, 08:26 AM
oeldere Re: if A3 has a number in,... 08-06-2012, 08:41 AM
Ace_XL Re: if A3 has a number in,... 08-06-2012, 08:47 AM
petelomax Re: if A3 has a number in,... 08-06-2012, 09:35 AM
ChemistB Re: if A3 has a number in,... 08-06-2012, 10:12 AM
petelomax Re: if A3 has a number in,... 08-06-2012, 10:38 AM
ChemistB Re: if A3 has a number in,... 08-06-2012, 11:00 AM
petelomax Re: if A3 has a number in,... 08-10-2012, 03:53 AM
petelomax Re: if A3 has a number in,... 08-10-2012, 06:19 AM
jason.b75 Re: if A3 has a number in,... 08-10-2012, 06:30 AM
petelomax Re: if A3 has a number in,... 08-10-2012, 06:37 AM
oeldere Re: if A3 has a number in,... 08-10-2012, 07:12 AM
jason.b75 Re: if A3 has a number in,... 08-10-2012, 06:48 AM
petelomax Re: if A3 has a number in,... 08-10-2012, 07:03 AM
jason.b75 Re: if A3 has a number in,... 08-10-2012, 07:07 AM
petelomax Re: if A3 has a number in,... 08-10-2012, 07:20 AM
jason.b75 Re: if A3 has a number in,... 08-10-2012, 07:45 AM
petelomax Re: if A3 has a number in,... 08-10-2012, 07:53 AM
jason.b75 Re: if A3 has a number in,... 08-10-2012, 08:44 AM
petelomax Re: if A3 has a number in,... 08-10-2012, 08:55 AM
smls Re: if A3 has a number in,... 08-10-2012, 09:00 AM
jason.b75 Re: if A3 has a number in,... 08-10-2012, 09:43 AM
  1. 08-06-2012, 09:35 AM #8
    petelomax is offline
    Forum Contributor
    Join Date
    04-24-2012
    Location
    Manchester
    MS-Off Ver
    Excel 2007
    Posts
    140

    Re: if A3 has a number in, show A1 details in Z1

    i've attached a snippet of the spreadsheet.

    what im after is if there is a number in cells G12 to AS12, in cell F12 i want it to read what is in cells G9:AS9. eg if there is a 1 in H12 and a 1 in K12, i want F12 to read what is in H9 and K9
    Attached Files Attached Files
    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)

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