IF() statements not working out right

[sumitos]

Hi Guys
Long time reader, 1st time posting

I've been having a issue with a if() statement on my workbook, KSCYC tab, Column E. For some reason cells E5 and E11 IF() wants to work correctly, but cells E7,9, 13,15 and 17 cannot find the #value or return a false in the Vlookup logical test. Not to sure if i'm missing something or getting the code back to front.
Any help would be appreciated.

Cell E5 IF() statement

=IF(VLOOKUP(B5,Members, 2, FALSE),VLOOKUP(B5,Members, 2,FALSE),"Member not in Database")

is returning a True logical test but
cell E7 IF() statement

=IF(VLOOKUP(B5,Members,3,FALSE),VLOOKUP(B5,Members,3,FALSE),"Add User Details")

is returning a #value error on the logical yet the data is correct on the same row.
I figure maybe a ISNA at the start may fix the issue but it returns a as 'value as false'

Thankyou


KSCYC Test1.xlsm

[vlady]

try the isblank

Please Login or Register  to view this content.

-> note the message first "member...." before the other vlookup

[FDibbins]

an IF() statement consists of 3 parts

a test
what to do is the test is valid/TRUE
what to do is the test is invalid/FALSE

Both of your if() statements start with a function, not a test...=IF(VLOOKUP(B5,Members, 2, FALSE)..is what???....= to something?...not = to something?....returns a value?....returns an error?
See what I mean? you start with the 1st part of the test, but you dont complete it. Vlad's suggestion is turning your vlookup() function into a test...=if(isblank(vlookup(). In other words if the vlookup returns a blank

although it should probably be shortened to...
=IFerror(VLOOKUP(B5,Members, 2, FALSE),"Member not in Database")

[sumitos]

Thank you Vlady for the quick reply on correcting my issue. All the codes worked nicely except for Type and Fee, not to sure why, but changing the 1st vlookups column index number from a 6 and 7 both to a 2 fixed it..go figure. all members when clicked show their detail.

To FDibbins
yeh i know i'm positive i'm if() dylexic somtimes.
Thankyou for the help and input but your shortened =iferror just leaves a blank cell return. i need something to return a text telling the person to add the user detail to the database as a reminder regardless of how much info that added at the start.
And the code Vlady provided worked as intended.