VLOOKUP response not changing based on logical test

[Rolaids24]

When I use this formula on 'Billing Master' DP2, it will work for logical test DO2 value of PT, but if you put anything else it will either show a 0 or keep showing GP (for PT) instead of the corresponding value. Any help would be appreciated!

=IF(ISNUMBER(DO2),VLOOKUP(DN2,Tables!A1:B6,2),"")

[AliGW]

Try this:

=IF(ISNUMBER(DO2),VLOOKUP(DN2,Tables!A1:B6,2,0),"")

[Rolaids24]

Well that worked. Thank you! So I had to have the FALSE (0) in there to tell it only an exact match? So exact match in this case just means there's data present in the cell I'm calling for? (I'm sure my basic terms aren't right, but just trying to understand better for the future!)

[AliGW]

Yes, that is correct - you need it to force an exact match (the default is approximate).

Glad to have helped.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED. You can also access the SOLVED tag by editing the opening post and choosing SOLVED from the drop-down to the left of the title box.

Also, if you have not already done so, remember that you can reward anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.

[Rolaids24]

Thank you very much for the explanation!