VLOOKUP: Prevent other values

Hi everybody!

First of all, I am an extreme novice with Excel. I have searched this forum for similar problems to the one I have, but could not find any. (I'm not even sure what this problem is called or which terms to use to describe it! - Please excuse my ignorance)

Please see attached screen shot.

I have this spreadsheet in which the only input of importance is a specific code (as in medical insurance ICD-10 code). For each specific code, an amount is allocated. The codes and amounts are in columns L and M.

A specific code is then entered in column D.
For example, if code "108" is entered in column D, the amount appears in column E.

I am using VLOOKUP to do this. (see code in screenshot)

Problem is, when entering a code which is NOT in the VLOOKUP range (not a specified code) ... for example 999, it still calculates a value for column E. (screenshot)

How can I "set a limit" so that only the specified codes, as show in the CODE/AMOUNT range, are accepted?

Thanks in advance for your help!

ExcelProb.jpg

Attachment 310192

Try using FALSE as the 4th argument in the vlookup.

=VLOOKUP(D2,$L$2:$M$15,2,FALSE)

Hi Jonmo1,

Works like a charm!!
Thank you so much!!!

MUCH MUCH appreciated!

Glad to help, thanks for the feedback.