Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Yes, but you have also modified the table so that where you had, for
example, 0.7500 1.50 before, you now have =0.750 1.50 This is a totally different value to Excel (i.e. text, rather than number), so your vlookup formula won't work. Max's suggestion will allow your formula to "fill in the gaps", as it were (well, with the original table), so that if a number is input which is not in the table then the number below it will be taken instead. Is this what you want? Pete |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
If / Vlookup Formula Help €¦!! | Excel Discussion (Misc queries) | |||
VLOOKUP result is not showing up - only the formula | Excel Worksheet Functions | |||
Vlookup formula Excel version 2002 | Excel Discussion (Misc queries) | |||
IF / VLOOKUP formula won't work until saved | Excel Worksheet Functions | |||
How do I use Range Names listed in a VLookup table in a formula? | Excel Worksheet Functions |