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!

I have now changed my formula to be the one below and it allows for a second
value to be the same but not the 3rd, 4th, 5th and so on....need help!!!

=IF(ISNA(VLOOKUP(E8,'DROP DOWNS'!D1:E10,2,0)),"0",VLOOKUP(E8,'DROP
DOWNS'!D1:E10,2,0))

"Carolina" wrote:

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!