I have a VLOOKUP problem...........
This formula doesn't work
=IF(B8<>"OVERHEAD","0","VLOOKUP(A2,Sheet1!A2:F1361,6")
Basically - if cell B8<>OVERHEAD - I want "0" and if B8="OVERHEAD" then perform the VLOOKUP
First part of formula works - I get zero 0 for non OVERHEAD values - however if the cell is "OVERHEAD" - formula returns VLOOKUP(A2,Sheet1!A2:F1361,6
How do I get this thing to work?
Thanks in advance..........
Maybe like this
=IF(B8<>"OVERHEAD","0","VLOOKUP(A2,Sheet1!$A$2:$F$1361,6,0)
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Didn't work - I get error message.............
Shouldn't there be another "...............you have "VLOOKUP(A2,Sheet1!$A$2:$F$1361,6,0) but no close " - where would the " go? I tried several places - no luck........
I got it.............thanks..........
=IF(B2<>"OVERHEAD","",VLOOKUP(A2,Sheet1!$A$2:$F$1361,6))
This worked - it put a blank if cell <> OVERHEAD and performed VLOOKUP if it did.........
Thanks AlKey - you got me started in right direction........I fixed by trial and error......
Please note that using VLOOKUP the way you did will only return an approximate match. For the exact results you need to use FALSE (or simply 0)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks