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

  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


    User Avatar
    Gold Member

    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:

    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


    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


    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