vlookup from excel in c++?

[russeld]

hey,
im a beginner in C++. I am writing a financial C++ program. I am trying to input a excel spreadsheet with interest rates in column a and spread in column b

i want the user to input the interest rate and i want to use a v lookup to tell them the spread.
I was going to use an if statement but the if will be 407 rows long

i appreciate it a lot!

[kbw]

How does C++ come into this? Aren't you doing it all in Excel?

[russeld]

no, im doing this as a console program in c++. Excel could do this task but i want to do it in c++.
I thought i could use the if else statement but i dont know the limits on that, how long can the if statement be?

another thing i thought about was putting the data in a static library but i dont know how i would retrieve it

thanks a lot