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
 
J

JulieD

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
 
J

Jim Berglund

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
Adding or to previously provided Average If Array function 4
No of entries between two dates 3
Formula IF 1

Top