Vlookup help

[CROY1985]

Hi all

need help with the following:

=VLOOKUP("????00", Data!2:$238, 2, FALSE)

This returns the 1st and 2nd piece of data i need ok, but then repeats the 2nd in every row where the lookup value is not ????00 until it finds the 3rd occurence of ????00 and this repeats until the 4th occurence of ????00.

I need the formula tweaked to ignore the rows that are not ????00, so i end up with no repetition.

Thanks everyone.

 

[pbornemeier]

It sounds as VLOOKUP is performing as designed.
Did you intend to have the first row of your lookup table change as you dragged the VLOOKUP formula down a column?

Perhaps you could use Data | Advanced
to create a filter (="=????00") with Unique records only checked to get the results you want. How to set the criteria on an advanced filter is not immediately obvious. See the help file for guidance.