ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   VLOOKUP Help (https://www.excelbanter.com/excel-worksheet-functions/266610-vlookup-help.html)

Bruceeboy
VLOOKUP Help
 
2 Attachment(s)
Hey all,
Ive been trying to figure this out for ages.
I'm trying to do the following:
In the Data worksheet insert a VLOOKUP function that will put the bonus from the Bonus column in the cell range (F2:F1001). The appropriate bonus is given in the last column of the VLOOKUP_Table worksheet. Use the range names Profit and VLOOKUP_Table in the VLOOKUP function.

For some reason i keep getting #N/A

wickedchew
Quote:
Originally Posted by Bruceeboy (Post 960396)
Hey all,
Ive been trying to figure this out for ages.
I'm trying to do the following:
In the Data worksheet insert a VLOOKUP function that will put the bonus from the Bonus column in the cell range (F2:F1001). The appropriate bonus is given in the last column of the VLOOKUP_Table worksheet. Use the range names Profit and VLOOKUP_Table in the VLOOKUP function.

For some reason i keep getting #N/A
Your BONUS column on your VLOOKUP_Table should be on column A instead of the Profit Column.


All times are GMT +1. The time now is 03:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com