Hi all of u
I have a data in master sheet.Currently I am using the formula vlookup in "Current" sheet.The pulled data I want to convert actually into the formula as mentioned in "required" sheet which is not possible one by one to do so if the data is large.
I hope this might be made possible.
I think you are saying you want to keep the results of the formulas.
Please Login or Register to view this content.
Last edited by skywriter; 12-03-2017 at 02:26 AM.
Click the * Add Reputation button in the lower left hand corner of this post to say thanks.
Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.
Thanx for the reponse.But it is not the thing I want.I did not like to paste value pulled by the formula ,rather I am expecting in the format as mentioned in "required"worksheet.
If you like to further info,kindly let me know.
I don't really understand what you want. But this single formula, copied across and down from D3 seems to do what you want (format as General):
=IFERROR(1/(1/VLOOKUP($B5,master!$A$6:$D$12,COLUMNS($A:C),0)),"")
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
The formula is working very fine in "Current" worksheet which I have already shown.The thing is that I want to convert the formula in the exact format as mentioned in "required" worksheet.For example-
In "current" worksheet,E5=IFERROR(VLOOKUP($B5,master!$A$6:$D$12,4,0),0),this I want to convert into,E5=master!D8 and likewise.As manually it is not possible as I have a large data.
Hope this would provide a clear view.
Why do you want to have formulae like =master!D8 and likewise? What advantage do you think it will have over a lookup that can be copied across thousands of rows in a few seconds???
I would also suggest that your formula does NOT work fine. It leaves " - " in cells that should be entirely blank. See manually shaded yellow cells.
I know but it is only a sample data.I am using the formula such as vlookup here.But I am giving to someone this file same result as in "Current" worksheet but the worksheet is "required" and not "Current" worksheet and the formula is different.Hence I want to replace the formula of "Current" worksheet into the formula as mentioned in "required" worksheet.
I hope now this would ease further to comprehend.
I have absolutely no idea what you want ... or why you want it... So, I will ask others to take a look.
If you change the format to General in the Current sheet, they will then match the format in the master sheet.
Don't mind the sloppy writing.
Master.JPG
Current.JPG
I, too, am unclear on the goal, but here's the most absolutely literal interpretation of your "current --> required" transition that I can conceive:
Hopefully that helps?Please Login or Register to view this content.
If your problem has been solved, please use "Thread Tools" to mark the thread as "Solved".
If you're grateful for this site's existence and would like to contribute to the community, please consider posting something hilarious in our joke thread:
https://www.excelforum.com/the-water...ke-thread.html
Thanx for your kind reply.But this is not what I am expecting.But the post #11 seems to be working and I am underway to that.Originally Posted by davesexcel
I think it seems to be working in this demo file. Plz wait I will be checking in the original file and soon get back to you if any further error occurs.I, too, am unclear on the goal, but here's the most absolutely literal interpretation of your "current --> required" transition that I can conceive:
Hopefully that helps?Please Login or Register to view this content.
And thankx a lot for this.As I am doing index match/vlookup function in my large file which is not possible manually if used manually as stated in my above attached file in "required"sheet.This is done as I have to give the file to someone who does not like those index,match,vlookup formula using there.Hence,would prefer simple linking to it.
Last edited by paradise2sr; 12-06-2017 at 02:38 AM.
ok while testing on my original workbook where index match is applied instead of vlookup, an error 400 is prompted.Can you let me know where I am wrong ?
The following code works on the excel file given by the OP.
May have to make some changes based on the actual structure of the sheets.
Please Login or Register to view this content.
My guess would be that the sheet names on your original workbook don't match the sheet names on your sample workbook. The procedure I provided should be run while the active sheet is the sheet you are changing, and the reference sheet is named "Master". If your "Master" sheet has a different name in the original workbook, either change the sheet name to "Master" or change the two instances of "Master" in my procedure to reflect the actual name.Can you let me know where I am wrong?
No it did not worked out.
I'm unable to guess the issue, then. Are you able to post a sample workbook that's closer to your actual workbook and returns the error?
I think you are just messing with us, you have not shown what you are after.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks