Thread
:
IF?
View Single Post
#
1
Posted to microsoft.public.excel.programming
shapper
external usenet poster
Posts: 22
IF?
Hello,
I have the following:
=10 + INDEX(B$47:K$52;MATCH($E3;B$47:B$52;0);3)
I get #N/A when there is not match.
How can I change it to have 10?
Thanks,
Miguel
Reply With Quote
shapper
View Public Profile
Find all posts by shapper