Vlookup in Microsoft Excel 2003 & 2007

many office users can use vlookup formula because of they didn't what is the function of vlookup. here I want to explain the function of vlookup formula. vlookup is powerfull formula to search data in another worksheet.

for example you have data like this


and then in other worksheet you have data PRNo of employee too. and you want to know the birthdata of each employee. because you already have data employee before you can vlookup the data and get the birthdata quickly with only one formula. if you want to avoid ISNA come up if the data is not available you can add ISNA in front of vlookup


the formula to find birth date in previous data
=IF(ISNA(VLOOKUP(B12,$B$4:$C$7,2,FALSE)),"",
VLOOKUP(B12,$B$4:$C$7,2,FALSE))

ISNA is used to give blank cell if encounter #NA

look the difference. if only use VLOOKUP and the result will be like this
the formula only like this
=VLOOKUP(B14,$B$4:$C$7,2,FALSE)

so you can see the difference betwen use ISNA and not use ISNA. the display will be better if you use ISNA