Goofiest Thing - VLOOKUP Error!

J

Jim Berglund

The formula for Cell O3 is =VLOOKUP(TRUE,Q3:R6,2)









It works if Q4,Q5, or Q6 are TRUE, but as you can see, not for Q3.



What could be wrong?



Thanks,

Jim
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMIFS ONLY UNTIL the number REPEATS 1
SUMIFS UNTIL the number is repeating 0
count if a match occurs 1
Custom Error Message When Database Not Updated 3
Excel Fill issue 2
Filldown recurring 121212 5
Formula IF 1
Database similarity 3

Top