+ Reply to Thread
Results 1 to 14 of 14

Looking for formula help. Cross reference rows and columns?

  1. #1
    Registered User
    Join Date
    07-01-2015
    Location
    USA
    MS-Off Ver
    2010
    Posts
    10

    Looking for formula help. Cross reference rows and columns?

    I'm looking for a formula to get the name of the column when any letter or number is placed in the crossing row.


    In my attachment I would like a formula to find the x (or any letters or numbers) and output what spot that person is in.

    Excel Help.xlsx
    Last edited by Bus; 07-01-2015 at 08:43 PM.

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,366

    Re: Looking for formula help. Cross reference rows and columns?

    I4 = ="spot "&match("x",$C4:$G4,0) and drag down.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    2,963

    Re: Looking for formula help. Cross reference rows and columns?

    Or maybe this formula
    Please Login or Register  to view this content.
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  4. #4
    Registered User
    Join Date
    07-01-2015
    Location
    USA
    MS-Off Ver
    2010
    Posts
    10

    Re: Looking for formula help. Cross reference rows and columns?

    Thanks!

    Both work great, however, currently it will only find whatever its told. Is there a way to make it find anything that is put in there including "x"s.


    Maybe some If statements with all the possible inputs.

  5. #5
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,366

    Re: Looking for formula help. Cross reference rows and columns?

    Give in your file a couple of examples and please add the expected result manualy in your file.

  6. #6
    Registered User
    Join Date
    07-01-2015
    Location
    USA
    MS-Off Ver
    2010
    Posts
    10

    Re: Looking for formula help. Cross reference rows and columns?

    Here is what they normally type, they do numbers sometimes because there is more than one position per machine or place they are telling them to go.


    Excel Help 2.xlsx

  7. #7
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,366

    Re: Looking for formula help. Cross reference rows and columns?

    With a macro.

    See the result on sheet output

  8. #8
    Registered User
    Join Date
    07-01-2015
    Location
    USA
    MS-Off Ver
    2010
    Posts
    10

    Re: Looking for formula help. Cross reference rows and columns?

    That gets the job done! Does that macro only run when I tell it to? or is there a way to make a button in a cell to run it. I'm quite new to macros and trying to learn all the functions is quite the task haha.

  9. #9
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,366

    Re: Looking for formula help. Cross reference rows and columns?

    Maybe you get started with the explanation in the treath below (#9 and #11).

    http://www.excelforum.com/excel-form...le-sheets.html

  10. #10
    Registered User
    Join Date
    07-01-2015
    Location
    USA
    MS-Off Ver
    2010
    Posts
    10

    Re: Looking for formula help. Cross reference rows and columns?

    Ok thank you much, I did find a way to use a command button in the activeX section so I solved that one . Thanks for the help, I'm going to start learning macros so I can eventually try this on my own.

  11. #11
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,366

    Re: Looking for formula help. Cross reference rows and columns?

    You're welcome. We appreciate the feedback!

    Thanks for the rep.

  12. #12
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,366

    Re: Looking for formula help. Cross reference rows and columns?

    Please follow the forumrules

    4. Don't Private Message or email Excel questions to moderators or other members. (or Word, Access, etc.) The point of having a public forum is to share solutions to common (and sometimes uncommon) problems with all members.


    Please Login or Register  to view this content.
    Last edited by oeldere; 07-06-2015 at 02:27 AM.

  13. #13
    Registered User
    Join Date
    07-01-2015
    Location
    USA
    MS-Off Ver
    2010
    Posts
    10

    Re: Looking for formula help. Cross reference rows and columns?

    Ah I never read forum rules that one is my bad, I did however figure out how to get around the #REF errors by adding a copy and paste to the end of the macro into a different sheet.

  14. #14
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,366

    Re: Looking for formula help. Cross reference rows and columns?

    Please share it on the forum, for the benefit of all forummembers.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Cross Reference two columns and return common values?
    By chewedbacca in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-27-2013, 12:29 PM
  2. Need a macro to cross reference several columns and grups of rows
    By mrswain in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-19-2013, 11:44 AM
  3. Replies: 2
    Last Post: 10-11-2012, 08:05 AM
  4. How to cross reference two columns of numbers
    By Danexcel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-09-2010, 09:52 AM
  5. Cross Reference multiple columns and copy
    By bsmith127 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-16-2009, 12:51 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1