If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Vlookup problem
Cannot understand why I am getting peculiar results with a vlookup query
on a table similar to one below. Using the formula =VLOOKUP(D1,A1:B7,2) where D1 is a drop down list created from the first column below and A1:B& is the range below as example. eg when D1 is Sylvinite I get value 132, same with Sulphate of potash 0.60.60 gives #N/A The rest if selected give the correct return. I would value any help. Sylvinite 42 Sulphate of potash 105 0.0.60 126 0.14.42 136 0.16.16 88 0.24.14 111 0.24.24 132 |
#2
|
|||
|
|||
Vlookup problem
Try adding the FALSE segment to your formula........
=VLOOKUP(D1,A1:B7,2,FALSE) Vaya con Dios, Chuck, CABGx3 "Graham Haughs" wrote: Cannot understand why I am getting peculiar results with a vlookup query on a table similar to one below. Using the formula =VLOOKUP(D1,A1:B7,2) where D1 is a drop down list created from the first column below and A1:B& is the range below as example. eg when D1 is Sylvinite I get value 132, same with Sulphate of potash 0.60.60 gives #N/A The rest if selected give the correct return. I would value any help. Sylvinite 42 Sulphate of potash 105 0.0.60 126 0.14.42 136 0.16.16 88 0.24.14 111 0.24.24 132 |
#3
|
|||
|
|||
Vlookup problem
Almost too embarrased to say thanks CLR, but thank you.
Graham CLR wrote: Try adding the FALSE segment to your formula........ =VLOOKUP(D1,A1:B7,2,FALSE) Vaya con Dios, Chuck, CABGx3 "Graham Haughs" wrote: Cannot understand why I am getting peculiar results with a vlookup query on a table similar to one below. Using the formula =VLOOKUP(D1,A1:B7,2) where D1 is a drop down list created from the first column below and A1:B& is the range below as example. eg when D1 is Sylvinite I get value 132, same with Sulphate of potash 0.60.60 gives #N/A The rest if selected give the correct return. I would value any help. Sylvinite 42 Sulphate of potash 105 0.0.60 126 0.14.42 136 0.16.16 88 0.24.14 111 0.24.24 132 |
#4
|
|||
|
|||
Vlookup problem
It's been said: "One who asks a question is a fool for 5 minutes, while one
who doesn't is a fool forever"............you're very welcome for the assistance, and any "Thanks" is always appreciated, especially one as heart-felt as yours........be welcome to come back anytime you want to..... Vaya con Dios, Chuck, CABGx3 "Graham Haughs" wrote: Almost too embarrased to say thanks CLR, but thank you. Graham CLR wrote: Try adding the FALSE segment to your formula........ =VLOOKUP(D1,A1:B7,2,FALSE) Vaya con Dios, Chuck, CABGx3 "Graham Haughs" wrote: Cannot understand why I am getting peculiar results with a vlookup query on a table similar to one below. Using the formula =VLOOKUP(D1,A1:B7,2) where D1 is a drop down list created from the first column below and A1:B& is the range below as example. eg when D1 is Sylvinite I get value 132, same with Sulphate of potash 0.60.60 gives #N/A The rest if selected give the correct return. I would value any help. Sylvinite 42 Sulphate of potash 105 0.0.60 126 0.14.42 136 0.16.16 88 0.24.14 111 0.24.24 132 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Problem with Vlookup array selection | Scott269 | Worksheet Functions | 2 | January 30th, 2006 05:29 PM |
VLOOKUP problem | Jaladino | General Discussion | 1 | March 2nd, 2005 04:02 AM |
VLOOKUP problem | Jason | Worksheet Functions | 2 | January 14th, 2005 10:39 PM |
Strange VLookup problem | Gordon | New Users | 4 | August 4th, 2004 03:41 PM |