LinkBack URL
About LinkBacks
I can't seem to make this work. How do I show someone the spreadsheet for help?
I can't seem to make this work. How do I show someone the spreadsheet for help?
attach here
Please upload a small clean sample of your data / workbook (not a picture) to the forum, Make sure you have removed any private information, remember this is a public forum and so available to anyone
We would like to see an example of your data and also a manual mock up of the expected results you want to achieve.
To attach a file to your post,
click "Go advanced" (next to quick post),
scroll down until you see "manage Attachments",
click that and select "Choose File" (top Left corner).
Find your file, click "Open" click "upload" click 'close windows" Top 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.
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
I think I have the file attached. New to this forum thing.
Any help would be greatly appreciated.
Last edited by AliGW; 02-26-2017 at 08:57 AM. Reason: E-mail removed by moderator to protect OP from spammers.
=VLOOKUP($A$3,$I$3:$J$42,1,FALSE)
You don't need the sheet reference
Vlookup looks in 1st column of range and looks to the right of that.
You started in col b which does not contain the reference value
I am not sure what value you are trying to return though. It may be that you will need a Match and Index function if you want to return a value from columns to left of column I
Last edited by philaugust2004; 02-25-2017 at 07:04 PM.
Ogoody - I've removed your E-mail address as the only forum visitors interested in it will be spammers and spambots.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Also, never a good idea to post personal info like that on a public forum
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks