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
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