Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Here is my formula that I'm looking to build off of:


I don't know if I can use just a formula or if it has to be a macro. I am trying to create a query of one column in a list. The query will be for an ID in column A. This query will be done against another worksheet in the same workbook. (Table1 and Table2)

If the ID of the first worksheet matches the ID in the other worksheet, it will copy data from column J of Table1 to column J of Table2.
There are only two columns that will be used in this formula. Column A contains IDs for the initial lookup while Column J contains the data that needs to be copied

My formula already works but I need it to actually copy the values over to column J instead of just referencing. If I need to explain better/more, I'd be more than happy to do that.

share|improve this question
Are you putting your formula in column J? Because you should, from what I can gather. – Excellll Dec 20 '12 at 1:47
do you want to copy the values, and have that overwrite the formula you use to retrieve the data? – SeanC Dec 26 '12 at 20:44

Would this do what you need?

share|improve this answer
Welcome to SuperUser I didn't downvote, but you might have received a downvote because it's difficult to tell what exactly the asker wants to do because there is no response to the comments. Also, note the date on the question. – Raystafarian Jul 26 '13 at 14:53

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.