If statement won't work on excel. Hi, just wondering how I could write an IF statement where if the number of the credit card starts with x then it should return "mastercard." Or I was trying to do a vlookup using =vlookup(J11,L12:m16,2,False). I also used 1 instead of 2 but it's not working. I think it should be right but is it not working because of the formula that I have in row J? Thanks for your input.

K Credit Card Number (First 4 Credit Card Network vlookup for card network Zip Code State (frist digit) Digits) #N/A 4597 OK 73109 OK 73109 4142 TX75243 75243 #N/A First Digit Card Network TX 4 67401 #N/A Visa Mastercard American Express 5180 KS 67401 KS 4 11581 #N/A #N/A #N/A 4018 NY 11581 NY 4 92253 6901 CA 92253 CA 3089 TX76645 TX 76645 Discover r 73104 #N/A 5709 OK 73104 OK 68410 #N/A #N/A #N/A VLOOKUP(J11,L12:M16,1,FALSE) 3107 NE 68410 NE 6098 NJ 07002 NJ 07002 NY 3789 NY 10001 10001 LEFT(F11,1)