I need help working out this function.
Cols B to J need to look at correspondeing Cols L to T
Col B looks at Col L
Col C looks at Col M
Col D looks at col N
and so on
I need the following to occur
COl B needs to look at Col L and then goto the Lookup table LEP and if there is a corresponding entry, key that in but if not then ABNI. BUT,,,, If ColB looks up Col L and there is no entry at all, i need it to stay blank.
The first 12 lines of my spreadsheet show how i would like it to look.
Every time i create my formula i keep getting ABNI to appear, even when the corresponding col has no entry. If there is not entry i need it to stay blank.
Bookmarks