Excel Formula with VLOOKUP -

i have excel spreadsheet 2 sheets.

on 1 sheet, labeled worshipleaders, have following in columns & b

col col b jimmy 500 johnny 300 billy 200

i'm trying second sheet (called schedule) populate column number worshipleaders col b when select name drop down list. i've got list part figured out, can't quite dial in vlookup.

here's formula i'm using working, grabs wrong number:

=if(not(isblank(b6)),vlookup(schedule!b6,worshipleaders!a:b,2),"") 

any appreciated.

try this=if(not(isblank(b6)),vlookup(schedule!b6,worshipleaders!a:b,2,false),"")