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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
"(e-mail address removed)" and don't sign up my email address for anything.
 
Try looking into OFFSET() to get the cell 2 rows over (columns?)

Concatenate:

=A1 & B1

Tim.


alomega said:
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
"(e-mail address removed)" and don't sign up my email address for
Click to expand...
anything.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create if partial match then copy and paste data from one cell to another 1
Save data from Notebook: copying to the USB stick using Linux and the command line 0
MATCH command does not work with dates 3
QUESTION with Match command and OFFSET 2
VB to specify criteria then paste to a new worksheet 1
I want to make One Cell mandatory if another cell has a specific value , can anyone help me? 0
Access Command button to look up and copy data from a query to a table 0
Copy Cell, Paste based on a match. 2

Back
Top