Vlookup error

Solved/Closed
Paula - Jun 27, 2010 at 01:14 PM
 Paula - Jun 27, 2010 at 01:52 PM
Hello,


I am having this error when I use the vlookup function, here is what I have:

Cell A Cell B

EDI 2222
EDI 2222
EDI 2222

I am using these formula =VLOOKUP("EDI",A2:B13,2) ..... this is the result 2222, which is good BUT when I use =VLOOKUP("NON-EDI",A2:B13,2) should return error or nothing instead of that is returning 2222 eventhought the text "NON-EDI" is not in cell A.. Do you know what is happening, what can I do???

Thanks


2 responses

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 27, 2010 at 01:30 PM
You need to add the fourth parameter "true or false"


VLOOKUP("EDI",A2:B13,2, FALSE)

better would be

=IF(ISERROR(VLOOKUP("EDI",A2:B13,2, FALSE)), "", VLOOKUP("EDI",A2:B13,2, FALSE)
0
Thanks a lot....... Have a great day
0