Hello and thank you for reading. Your Help would be greatly appreciated. I have a situation that goes as follows:
In sheet1 I have a code on one colum and a written formula on the next. on sheet2 i would like to create a formula of some sort that will allow me to use a vlookup or a match that will look for the code on sheet1 and input the working function on sheet2. is that a possibility?
please help me.
My kindest reagards
J
HI
yes, it is, but you need VBA
Ok.. Im no expert... but how would i go about that?
It might help if you provided a sample of what you are working with - and what you want?
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
Why don't you just put the working formula on Sheet1 then you can use a simple VLOOKUP formula on Sheet2.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Here is a sample of something Im looking for. Thank you again for all your help.
Do it like this...
On the Codes sheet enter these formulas:
B2: ='Result Sheet'!B2*'Result Sheet'!C2
B3: ='Result Sheet'!B3*45
B4: ='Result Sheet'!C4*0.87
B5: =IF('Result Sheet'!B4<'Result Sheet'!C4,"No Reserve",'Result Sheet'!B4+'Result Sheet'!C4)
On the result sheet...
Enter this formula in D2:
=VLOOKUP(A2,Codes!A$2:B$5,2,0)
Copy down as needed.
that will not work because there are 1000 rows on the original sheet. I want to automate the process of that result colunm.
Ok, as noted by Pepe, you'll need VBA to do what you want.
I suggest you start a new thread in the Excel Programming / VBA / Macros forum and include a link to this thread so that people can see what has already been discussed.
Good luck!
thank you so much your help is greatly appreciated
You're welcome. Thanks for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks