I am entering a LOOKUP formula that I've used on other worksheets. I vaguely recall there being some obscure issue when originally building the formula that was causing it not to accept it as a formula, but I can't remember what that was. Now I'm typing it in directly in a new worksheet and, once again, it says there's something wrong with the formula. I've checked my formatting and the display formulas toggle and all of that's okay. I type in
=LOOKUP(2,1/B2:B6=B7),C2:C6)
with no luck, however, when I copy the formula from the other worksheet and then adjust the cell addresses as appropriate, it works just fine. What is it that I could possibly be copying from that first worksheet that I haven't got right in my new one?
Hope this makes sense! Thanks!
- Jan
=LOOKUP(2,1/B2:B6=B7),C2:C6)
with no luck, however, when I copy the formula from the other worksheet and then adjust the cell addresses as appropriate, it works just fine. What is it that I could possibly be copying from that first worksheet that I haven't got right in my new one?
Hope this makes sense! Thanks!
- Jan