C
cfortran
I've got a spreadsheet where I need to search a table and return a
value from a particular column in that table. Vlookup appears to be
exactly what I'm looking for, however the first argument I need to
pass it (the value to search for) is located in cell N2. Cell N2 is
itself a formula and it appears that it is making vlookup fail. Is
there a way I can tell the vlookup function to only use the result of
the formula in that cell instead of following the formula itself?
Thanks
--cfortran
value from a particular column in that table. Vlookup appears to be
exactly what I'm looking for, however the first argument I need to
pass it (the value to search for) is located in cell N2. Cell N2 is
itself a formula and it appears that it is making vlookup fail. Is
there a way I can tell the vlookup function to only use the result of
the formula in that cell instead of following the formula itself?
Thanks
--cfortran