I've been using vlookup for years. Recently, it has stopped working properly for me.
I have two sheets in the same file. When I use vlookup from sheet 1 to find a matching value on sheet 2 (Lawyers), I get #N/A in all cases.
My cell formula is =Formula:vlookup(M9,Lawyers!A2:E50,3)
Could someone please shed some light on this for me?
Bookmarks