So I have data set 1 in Column A, which is connected to data set 2 in Column C. Separately, Data set 2, differently ordered, is connected to data set 3 in Columns K and L, respectively. I Want Column D to contain Data 3 rearranged to match the data in column C. This is the Current Formula I am Attempting to use:
=Cell("Contents", ADDRESS(MATCH(C3,$K$2:$K$1033,0)+1,12,3,1,))
I am getting the "there's a problem with this formula" textbox error, And i cant tell why. any ideas?
Last edited by swankcookie; 01-05-2017 at 05:25 PM.
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Hi and welcome to the forum
The ADDRESS() function returns Text. The second element of the CELL() expects a range.
You may be able to use an INDIRECT function rather than the CELL() function. But upload the workbook so that we have something to work with and explain what result you expect to see.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
CELL needs an address to use, looks like you are just giving it a number value?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Sample has been uploaded.
That worked perfectly! thanks for your help.
This worked Perfectly! Thanks.Originally Posted by Richard Buttrey
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks