VBA Vlookup help please

[ashmott]

I have a very basic v lookup which i cant get working.

The lookup searches for a range of values 1-4 then returns the corresponding value from column 3 of a seperate worksheet.

The problem is that where i expect the lookup to return a blank value (i.e. it finds a match in the table but column 3 for the match is blank) it is instead returning the value of the previous lookup result.

I have attached the file if someone could please help a desperate newbie.

Many thanks in advance.

Ash

[Mordred]

I ran your code, in your workbook and had no problems. Sheet 2 Range C3 was blank. I ran it multiple times and there seemed no mistakes.

[ashmott]

My apologies i have slightly changed the table values.

The issue is where the lookup value in Sheet 2 is not found in sheet 1. If you run it now i think the code will returs a value of 4 when it searches for value 5. However 5 should not be found in column A of sheet 1 which is the lookup table.

I really appreciate your help, this is driving me mad and i know it will be someone silly on my part.

Thanks

[Mordred]

That is baffling.

[ashmott]

Not only baffling but extremely annoying

Can you think of another way to produce the same desired outcome?

[Mordred]

I will post this for other who are far more talented at this than I so be patient and you'll have an answer soon I'm sure.

[NBVC]

Shouldn't the vlookup in the code have a 4th argument, FALSE to find exact match?

Please Login or Register  to view this content.

[ashmott]

NBVC that looks like the answer. You have just attained legend status in my humble opinion. Thankyou

[Mordred]

@NBVC, I tried that after some research earlier and it didn't seem to make a difference to me. This is what I had done

Please Login or Register  to view this content.

I just ran it again and it still doesn't work.

[NBVC]

It worked fine for me