Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

keeper

macrumors 6502a
Original poster
Apr 23, 2008
526
304
Hello

I have an Excel spreadsheet used to track fund values, It looks down the column for the latest value to populate a cell.
I've not used numbers before and although it imported the spreadsheet the lookup does not work.

Can anyone confirm how I would amend the formula below??

VLOOKUP(9.99E+100,$C$21:$C$37,1)

Thanks
 
Problem is in 2nd parameter. It needs to be multiple columns that includes the column you want a value returned from. Try $C$21:$D$37 for that parameter.
 
That does not seem to work if you look at the screenshots, numbers seems to return the first value rather than the last.
 

Attachments

  • Screenshot 2022-03-08 at 12.39.38.png
    Screenshot 2022-03-08 at 12.39.38.png
    279 KB · Views: 92
  • Screenshot 2022-03-08 at 12.38.31.png
    Screenshot 2022-03-08 at 12.38.31.png
    210.9 KB · Views: 69
Last edited:
The “1” in your formula tells it to pull the value from the first column in the range provided in the previous function argument. If you want the data from column D, for example, this argument would need to be “2”.

If you want this value to change based on the current date, then you’ll need to build a formula to calculate which column to retrieve data from for your chart.
 
That's interesting , excel does not require a lookup on the date.
 
This seems to work
INDEX(D22:D37,COUNTA(D22:D37))

However in the Excel version you can keep adding rows, but its a stat I can work with....
 
Last edited:
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.