I have excel 2007 and I have a column that contains drop down boxes thats tied to a list. I am looking for a way to search the whole column for a word that may or may not contain that word and then if it finds it return a number from another column in the same sheet. I have read about vlookup but not sure if that is what I need or not.
Many Thanks!
Adam
Last edited by putnum; 12-13-2009 at 05:32 PM.
VLOOKUP sounds exactly like what you need. Do you need any assistance with VLOOKUP?
Yes could you help me? I have done simple if statements but would love the help!
Sure, I am by far no expert, but I have used VLOOKUP several times. Can you attach a sample sheet of what you are working on?
Sure what I need is on Mini-Dashboard A5 to check CurrentPayCheck E5 to see if there is a match and if so return the tag amount back to Mini-Dashboard A5.
Make sense?
Try this, the only thing that had to be done is move the "Categories" column to column A. VLOOKUP searches down Column A until it finds a match, then goes left to the column specified, (in this case column 7 or G), and returns the value in that cell.
It looks like you are working on the same thing I am....A personal finance calculator. I have mine just about finished.
See this link for help on how to use VLOOKUP
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
Sorry its Mini-Dashboard A2 to check CurrentPayCheck E5 and return the tag amount for the item in Mini-Dashboard A5.
Sorry about that!
Hello putnum, welcome to the forum. However, ...
Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
regards
Originally Posted by teylyn
Thanks for the welcome! Sorry about the title I have corrected it and hope its ok now.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks