The new forums will be named Coin Return (based on the most recent vote)! You can check on the status and timeline of the transition to the new forums here.
The Guiding Principles and New Rules document is now in effect.
Some help with Open Office Calc ?
Turner
Registered User regular
Registered User regular
deleted.
Turner on
0
Posts
A3=VLOOKUP(text(A2); $NEWSHEET.A1:B150;2;0)
Edit: Hmm... actually I just tested it in my OpenOffice Calc and just using your basic premise, it just works as it should, so I'm not sure why it's not working for you as is.
Edit2: Is it possible you're just rounding off the answers? I mean, I used 7.986 as you did, and an entered value of say 9. This gives me 71.874, but by default only shows 71.87 unless I change the formatting to display more digits. So if my table contained 71.87, but not 71.874, it would return an #N/A, but if I typed in just 71.87 into the vlookup it would return correctly. If your vlookup table is sorted, you could quickly test if this is what's happening by just changing the last argument in the function to a 1 instead of 0. This will perform a lookup on the closest number less than or equal to the target.