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.
|