Function not working although it should?

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
Hi,

And you're using a version of Excel in which the argument separator is comma, and not semi-colon?

Regards
 
Upvote 0
Can't look at the images

But VLOOKUP is simple enough
so

=VLOOKUP($C17,$B$2:$J$10,COLUMN(D17)-1,0)


OR

=VLOOKUP($C17,$B$2:$J$10,3,0)

so C17 is the players name on the same sheet as the data to look up and there is a exact copy of the name which is found in column B between B2 and B10, and you want to return column D which 3 offset from B

Questions why did you use COLUMN(D17)? does the lookup data extend below row 10?
 
Upvote 0
Do you normally use commas to separate arguments in formulas, or semicolons (or another character)?
 
Upvote 0

Forum statistics

Threads
1,213,497
Messages
6,113,998
Members
448,541
Latest member
iparraguirre89

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top