Error Unable to Get Vlookup property

[JP555]

ID	PM	REF	DESC
1	11	22	une
2	22	23	ti
3	33	43	ai
4	44	55	ajo
5	55
6	66

For this table I want to get values that Ref = PM and want to get the value of DESC. I wrote this code but I don't find what's wrong.

Please Login or Register  to view this content.

Please give me a suggestion

[Pete_UK]

Why have you defined "v_master" as the two cells C3:C4 ? Surely your table should cover B2:D7, with the lookup value searching column B. You want to return the value from the 3rd column of this table, not the second.

Hope this helps.

Pete

[JP555]

no that is defined as 2 columns, the 3rd and the 4th because i dont know how much values would be. thank you anyway.

[MrShorty]

Debugging can be a frustrating, but essential part of coding. If you are unfamiliar with the various debugging strategies, I would suggest that you learn the tools and strategies available: http://www.cpearson.com/Excel/DebuggingVBA.aspx One of the most useful, I find, is the ability to step through a procedure one line at a time.

With VLOOKUP() or other lookup functions, the usual error is that the lookup value (v_item) is not present in the left column of your lookup table (named range "v_master" which refers to columns 3 through 4). I would suggest that you step through the code and, just before it executes the lookup statement, look at the values in v_item and compare that to what you know is in column 3. Check the value of v_item to make sure it is the value you expect, make sure that v_master is pointing to the range you expect, then make sure that the value of v_item (11 if I followed correctly) is present somewhere in column 3 (which it does not appear to be).

[Norie]

The first value you look up, 11, is not in column 3.

[JP555]

thank you for suggestions of debugging the column that I want to appear is: #n/a une #n/a #n/a ajo #n/a. I want values for PM that are reggistred before in REF and Desc.