Hi,
I cannot seem to get the correct syntax for the listed criteria.
Thanks Dave
Hi,
I cannot seem to get the correct syntax for the listed criteria.
Thanks Dave
A vlookup is usually written as =VLOOKUP(value you are looking up, column with the lookup value:column with value you want returned, number representing the number of columns over that contain the return value, false (meaning exact value) or true (meaning approximate value))
so
=VLOOKUP(A2,Sheet2!B1:C100,2,false) means that it will find the value in A2 in sheet2 somewhere down column B and look at column C and return the value across from it.
Hope that helps.
EDIT: and you can add $ to lock in ranges like Sheet2!$B$1:$C$100 locks in that range.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Can you show us what you have tried?
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
I can't add attachment
You need 1 more most before you can add an attachment (how did you try, anyway?).
Tell us what you have tried before?
Created lookup table, below is the criteria
Lookup Employee number VLookup, if match Lookup Age, if < 50 go to Admin and get maximium contribution amount else > 50 maximium.
vlookup employee find
Traditional - calc methods and determine if it is gross pay or default amount; if gross (rate*annual hours)*traditional amount (percent). If it is default (fixed amount); Traditional Amount * pay periods)
Roth - calc methods and determine if it is gross pay or default amount; if gross (rate*annual hours)*traditional amount (percent). If it is default (fixed amount); Traditional Amount * pay periods)
Both amounts added together < Limit or Limit is ending value in C22
OK so try to attach your DUMMY file now?
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"
Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.
Was not able to find add button.
I scrolled down to manage attachments - selected file from computer - could not find add attachment to email.
You dont add it to an email, you just upload it to the forum.
When you click GO ADVANCED (at the bottom of the window where you type your post), a new window will open that looks a bit different from this 1. You will see whatever you typed, in a box near the top.
Scroll down a bit, on the left you will see a heading Attachments, click the link Manage Attachments
Another new window will open - again different - click CHOOSE FILE (near the top), find your file click on it and click OPEN, then click UPLOAD/CLOSE THIS WINDOW
You will go back to the "2nd window", click SUBMIT
I've attached
If I understand post #6 then the following should do what you want.
I added a number of cells in row 22, columns E:J, which may be moved and/or hidden for aesthetic purposes.
E22:I22 are populated using formulas similar to: =IFERROR(VLOOKUP(TEXT($D$22,"000"),TL_LOOKUP,3,FALSE),0)
J22 is populated using: =IF(C22<50,lESS_50,GREATER_50)
C22 is populated using:Formula:Please Login or Register to view this content.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks