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
Sub string1() Dim a As String a = Cells(2, 4) MsgBox Cells(2, 4) & Cells(2, 5) & Cells(2, 6) End Sub
"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.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
One way: Structure your data as a database table and do queries. The trick lies in indexing the data...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?