Ms Excel vlookup in IF statement?

the source is from someone that asked a similar question. i gave an answer that he understood. hope it works for you too.

you want to use the ISNA() function

basically his formula was this

=IF(ISNA(VLOOKUP(C18,Rate s!A3:B20,2,0))," ",VLOOKUP(C18,Rates!A3:B2 0,2,0))

if it searched and didnt find anything in the Range, then it gave a blank .

if its still not working, if you would post your vlookup, i could copy&paste it to look like something like this. if you want a different result, let me know.

use the vlookup function. Create table with a new child's call and age in adjoining colums. Then creaet yet another little table exhibiting the age-classification hyperlink you desire in adjoining columns. Then use the vlookup function to look reference table a million (names and a while) to table 2 (a while-classification). =vlookup(b2,$d$a million:$e$10,2,0) "b2" is the place the childs age is; "$d$a million:$e$10" is a locked variety the place you placed the age-classification table. the particularly cellular reference will variety in step with what share rows you have in that table. The "2" tells the formulation to examine the cost in "b2" and go the the 2d column as quickly because it unearths it. The "0" tells it to discover the right experience. in case you do no longer use the "0" it's going to discover the closest experience.

To determine if the result is non-empty, you could combine your logic with the LEN function to test to see if the result has more than zero characters.

So, if your VLOOKUP is like this:

=VLOOKUP(A1,B:C,2,FALSE)

This version would look like this:

=IF(LEN(VLOOKUP( A1,B:C,2,FALSE))=0 ,"Empty",VLOOKUP( A1,B:C,2,FALSE))

Of course, you could replace "Empty" with anything you would like to return.