Vlookup with 2 Lookup Values
Vlookup can lookup 2 criteria too ! all you need to do is to use it in conjunction with If Formula & Istext formula . Like in this vlookup video I have looked up sales data of Sales reps via their Ids or Names so if you enter the name or employee id the sales data would show up.