See attached.
1) I have 2 columns of data in the "Data" worksheet.
2) In Sheet2 I have formulas that I entered manually
3) I would like to use the formulas in Sheet2 to get create the information in Sheet1.
How can I copy the Sheet2 formula and make the output on Sheet1? The output on Sheet1 should be the second column in the "Data" worksheet.
Is this what you need? Put this formula in Sheet1!C3 and copy to the right
=VLOOKUP(Sheet2!C6,Data!$C$7:$E$11,3,0)
Sorry.. my mistake. The data in Sheet2 will have different formulas included. It will not be exactly the same info in the columns of the Data worksheet. See attached.
The second example is just more confusing. I have no idea how you expect to get the data in Sheet1 based on the data in Data and Sheet2.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks