Unable to place VLOOKUP code in address bar for worksheet cell

[ipbr21054]

Please see attached screenshot
I select the cell C20 which is the green one in image.
In the address bar i paste & also typed =IFERROR(VLOOKUP($B20,$F:$H,3,FALSE),"")
but when i the hit enter to have it applied when i click in cell C20 nothing is shown.

I expect to see the type formula there.
Im trying to have the cell populate the text from the yellow cells top right.

 

[etaf]

should not return a zero for N/A - as you have "" in the IFERROR()
it will only return a zero - if it finds a matching value in F - BUT a blank in H

you could say

=IFERROR(IF(VLOOKUP($B3,$F:$H,3,FALSE)=0,"", VLOOKUP($B3,$F:$H,3,FALSE)),"")

 

[ipbr21054]

That worked thanks

 

[etaf]

you are welcome