I want to combine a "match" command with a copy and paste command.
 

I want to add the contents of another cell 2 rows over fromthe current
refernce information provided by the match commnad. I'm using "0" as the
qualifier for the "match" command. But I don't know if, and how to
concantenate the additional cell information. Please reply to
" and don't sign up my email address for anything.

I want to combine a "match" command with a copy and paste command.
 

Try looking into OFFSET() to get the cell 2 rows over (columns?)

Concatenate:

=A1 & B1

Tim.


"alomega" wrote in message
...
I want to add the contents of another cell 2 rows over fromthe current
refernce information provided by the match commnad. I'm using "0" as the
qualifier for the "match" command. But I don't know if, and how to
concantenate the additional cell information. Please reply to
" and don't sign up my email address for
anything.