Hi guys can anybody assist me with a formula please?
The following logical test is giving me successful results, but I also want to add an "ISNA", i.e. so that I not only exclude values which equal 0, but also the #N/As.
=IF(VLOOKUP(B2,Global,7,FALSE)=0,"",(VLOOKUP(B2,Global,7,FALSE)))
Last edited by _Lewis; 06-28-2011 at 07:08 AM.
It would be like this:
=IF(ISNA(VLOOKUP(B2,Global,7,FALSE)),"",IF(VLOOKUP(B2,Global,7,FALSE)=0,"",(VLOOKUP(B2,Global,7,FALSE))))
Although performing the vlookup 3 times to get your result is quite inefficient. I'd be tempted to do the Vlookup in a spare column and then do the tests on the result to return what you require.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
fantastic thank you - will look into a helper column but this will do for now
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks