Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. if statement won't work on excel. hi, just wonderi

If statement won't work on excel. Hi, just wondering how I could write an IF...

60.1K

Verified Solution

Question

Accounting

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.

image

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)

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Biology
1.2K views

Technology has changed the way scientists conduct their research. Select the ways the film supported...

Finance
1.2K views

What is the future value of $2,200 per year for 29 years at an interest rate...

Advance Math
1.2K views

The population of the United States has grown at different rates over ten-year increments as shown...

Accounting
1.2K views

United Motors specializes in producing one specialty vehicle. It is called Surfer and is styled to...

Biology
1.2K views

estion Points 2 What was the challenge faced by the Divine Right theory during the...

Algebra
1.2K views

1 Points DETAILS State the property of real numbers being used 6 A B 6A...

Accounting
1.2K views

I some ideas with this; External Proposal. This will persuade a relevant company researched Change...

Accounting
1.2K views

From this partial advertisement: $110.34 per month for 60 months $4,900 used car cash price...

Accounting
1.2K views

Fletcher Company collected the following data regarding production of one of its products. Compute the...

Accounting
1.2K views

RAR Corporation issued $500,000, 7%, 10-year bonds on January 1, 2011 when the market rate...

Finance
1.2K views

I "If an investor purchases a bond when its current yield is higher than the...

Finance
1.2K views

1- Assume that the risk-free rate increases but the market risk premium remains constant. What...