How to use Vlookup in google sheet and set some text if any text is not found?

 Hi All,

If you want to use Vlookup in google sheet and wondering how to do, please use below code.
I had 3 sheet and was refering 3rd sheet for values.

=IFERROR(VLOOKUP(D4,Sheet3!$B$1:$C$769,2,0),"NOT FOUND")

$before column will lock column and same way $before row will lock row like $B$1 .


Hope this small code will work many of you.
 

Download Netsuite Guru Android App
Follow Me on Linkedin
Our FB Page