Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Excel data return

Tags:
  1. Nov 14, 2015 #1
    If I want to lookup row 3 column "amz" and the end result will be side by side, how do i do that Example: a=.4 m=.91 z=.22
    input; amz
    output: .4.91.22
     
  2. jcsd
  3. Nov 14, 2015 #2

    phinds

    User Avatar
    Gold Member
    2016 Award

    Don't know how you would do it in Excel formulas but here's how you do it in VBA (as an example)

    I've put the kind of strings you show into 3 consecutive cells:
    string1.JPG

    Then created a VBA macro:
    Code (Text):

    Sub string1()
      Dim a As String
      a = Cells(2, 4)
      MsgBox Cells(2, 4) & Cells(2, 5) & Cells(2, 6)
    End Sub
     
    and the result is ".1.2.3"
     
  4. Nov 16, 2015 #3

    Svein

    User Avatar
    Science Advisor

    "Column amz" is meaningless in Excel. The only thing I can think of that has any meaning is (R3,Ca)&(R3,Cm)&(R3,Cz) In these expressions R=row, C=column and "&" means "concatenation" (strings joined together). Post #2 gives a hint as to how to do the concatenation, but parsing the "amz" part is tricky.
     
  5. Nov 21, 2015 #4
    Well if what I was hoping for won't work then how can I quickly pull data from multiple cells, even if I have a lot of data to pull?
     
  6. Nov 22, 2015 #5

    Svein

    User Avatar
    Science Advisor

    One way: Structure your data as a database table and do queries. The trick lies in indexing the data...
     
Know someone interested in this topic? Share this thread via Reddit, Google+, Twitter, or Facebook




Similar Discussions: Excel data return
  1. Histograms in Excel (Replies: 4)

  2. Excel summing (Replies: 3)

  3. Excel + Calculations (Replies: 9)

  4. Excel alternative (Replies: 9)

Loading...