Advanced Excel. Using an embedded IF statement with VLOOKUP

A complete explanation and demonstration on using an embedded IF statement in conjunction with VLOOKUP
The file can be downloaded for practice for free from :
Look for the file "Vlookup with embedded If"

[gopalakrishnarao]

Excellent explanation. Really very very useful. Thanks on behalf of all the Excel learners/users/addicts. Please post some more useful videos.

[merillwithanage]

Excellent way to enhance Excel knowledge to any one interested. FOC!

[umeshmishra]

i saw your u-tube video sir found very nice expaination regaring vlookup n if usage. i like it

[ry]

I can totally follow and understand this tutorial, BUT it would probably be next to impossible for me to actually figure out how to write this function in real life staring at the blank spreadsheet!

[ashpanch]

hi would this formula work as well
if(c4=yes, =vlookup(b4, $g$4:$i$10, 2, true), =vlookup)b4, $g$4:$i$10, 3, true).

[sumit]

Sir can we use more than 3 condition with IF along with WELOOKUP??