C
cfortran
I have rearranged my columns so that vlookup is happy (searching the
left column only of the table argument). Here is my formula:
=vlookup(n2,b6:c6006,2,true)
I would prefer to have 'false' as the last argument, but it doesn't
see the match (although I know it is there). Could this be a floating
point problem or something? With 6000 values ranging between 8 and 80
it doesn't appear to be matching precisely. N2 for example, currently
contains 20. With the vlookup formula shown above it instead finds
19.98 (right above the right answer of 20) and returns the C column
value next to it.
I'm afraid I'm an excel dummy. It's not making much sense to me at
this point. Thanks for any help.
--cfortran
left column only of the table argument). Here is my formula:
=vlookup(n2,b6:c6006,2,true)
I would prefer to have 'false' as the last argument, but it doesn't
see the match (although I know it is there). Could this be a floating
point problem or something? With 6000 values ranging between 8 and 80
it doesn't appear to be matching precisely. N2 for example, currently
contains 20. With the vlookup formula shown above it instead finds
19.98 (right above the right answer of 20) and returns the C column
value next to it.
I'm afraid I'm an excel dummy. It's not making much sense to me at
this point. Thanks for any help.
--cfortran