View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams Tim Williams is offline
external usenet poster
 
Posts: 1,588
Default 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.