Hi All,
I need some help please. (I will get my head round excel one day)
I'm using a vlookup to find a number and then use another vlookup to find another number, and then add them up. So far so good.
My problem is when i get a N/A for a number. How do i get N/A to = zero and then add the number found.
Thanks in advance.
Ben
I need some help please. (I will get my head round excel one day)
I'm using a vlookup to find a number and then use another vlookup to find another number, and then add them up. So far so good.
My problem is when i get a N/A for a number. How do i get N/A to = zero and then add the number found.
Thanks in advance.
Ben