Try:
Formula:
=IF($A$3="","",VLOOKUP($A$3&$BM2,INDIRECT("'Valid DL'!$C$2:$L$"&'Valid DL'!$M$1),2,FALSE))
Notice the 4 '
Try:
Formula:
=IF($A$3="","",VLOOKUP($A$3&$BM2,INDIRECT("'Valid DL'!$C$2:$L$"&'Valid DL'!$M$1),2,FALSE))
Notice the 4 '
Sincerely
S?ren Larsen
"Give a man a fish, and you'll feed him for a day. Give a man a fishing rod, and he'll steal your yacht!"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks