Goofiest Thing - VLOOKUP Error!

  • Thread starter Thread starter Jim Berglund
  • Start date Start date
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
 
Hi Jim

use the fourth parameter in the VLOOKUP function of 0 then it works whereever true occurs, otherwise you're looking for an approximate match.

e.g.
=VLOOKUP(TRUE,Q3:R6,2,0)
--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway

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
 
Thanks, it works great, now

....but what's approximate about finding TRUE?

Jim
Hi Jim

use the fourth parameter in the VLOOKUP function of 0 then it works whereever true occurs, otherwise you're looking for an approximate match.

e.g.
=VLOOKUP(TRUE,Q3:R6,2,0)
--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
...well i'm working on it anyway

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
count if a match occurs 1
Series fill in Excel 2003 problem 2
Database similarity 3
Need to stop VLOOKUP formula changes 2
filldown recurring 121212 2
Adding or to previously provided Average If Array function 4
Formula IF 1

Back
Top