In worksheet 1, column E I have
1 Bedroom
2 Bedroom
2 Bedroom
3 Bedroom
1 Bedroom
Studio

In worksheet 2 (called "DROPDOWNS"), column D & E respectively I have:
1 Bedroom 1B
2 Bedroom 2B
3 Bedroom 3B
Studio ST

I want to do a vlookup in worksheet 1, colum D that will lookup the values
in worksheet 2 and return the values from column E.

I used the following formula : =VLOOKUP(E8,'DROP DOWNS'!D2:E11,2,FALSE)

The formula works great until it fnds that it has already looked up the same
value and the second time around it returns an N/A. How can I make the
formula ignore other previously found values and just return the exact value
from worksheet 2.

Thanks!