vlookup returns NA after a second value returned the same

C

Carolina

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!
 
C

Carolina

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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Index/Match for the largest value that matches 1
Need to figure out Annual Rents 2
Working with IF functions 3
Comparing 2 columns from 2 different Worksheet and Returing Value of a 3rd column 2
Multiple VLOOKUP in an IF statement 2
Returning 1 of 4 values if conditions are met 4
Vlookup and return sheet name also 2
?? Some kind of look up function - Help and Thanks A Lot! 2

Top