Example:
In column c7 I enter a code for example 451, in column do I have the formula =if (c7=0,"",Lookup(c7,x6:y540))
Which looks up the name and returns it to do. I have many of these formula ando it slows excel down very badly, I have tried match and index but they return #NO
and #VALUE. What alternative formula can I use so as not to slow excel down?
Bookmarks