Hello All,
I have done a vlookup and it isnt working properly this is what i have done so far =VLOOKUP(H9,sheet4!A2:E10579,2) AND =VLOOKUP(H9,sheet4!A2:E10579,3)
when i am entering results it seems to be producing cells close to my target one. Im wondering whether its because im searching for UK postcodes so letter number combinations
Is there something im doing wrong or is there a better way of doing this
Kind regards
ricky
Try by adding last parameter of VlookUp..
=VLOOKUP(H9,sheet4!A2:E10579,2,FALSE)
Regards!
=DEC2HEX(3563)
If you like someone's answer, click the star to give them a reputation point for that answer...
You need the last parameter, parameter 4, to be set to False for an exact match.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
hi ricky. mostly likely, a FALSE or 0 will solve your problem:
=VLOOKUP(H9,sheet4!A2:E10579,2,0)
or
=VLOOKUP(H9,sheet4!A2:E10579,2,FALSE)
that is to find an exact match. if it did not solve your problem, upload a sample file & manually key in your desired results.
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
test vlookup.zip
hi all this is my table i tried your suggestions unfortunatly they did not work.
any help would be great
thank you all
ricky
As you didn't feed back in your perivious thread..
http://www.excelforum.com/excel-gene...60#post3398860
i am just curius if was ok
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.
Please stop duplicating same query..
Would like to continue in the previous thread..
http://www.excelforum.com/excel-form...g-results.html
@ MOD / ADMIN
Please close..
figured it out myself thanks to those who helped
You're welcome.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks