i have attached my workbook that has the problem.
i am looking for a value from a drop list but some of the information being returned is correct and then other values are coming back incorrect.
could you please tell me where im going wrong.
thanks
wayne
Are you sure that uploded the correct worksheet? Where is the drop down list? Where is the formula?
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
you need to add in the last part of the vlookup...
=VLOOKUP($Y$6,A:C,3,0)
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
columns y, z and aa have the tableOriginally Posted by Fotis1991
Are you sure that uploded the correct worksheet? Where is the drop down list? Where is the formula?
fdibbins... thank you.... it was the ,0 i needed... doh
Last edited by wayneg; 05-20-2013 at 04:48 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks