Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
INDEX? VLOOKUP?
Hey guys
, I'm working on some data and not sure if V LOOKUP or INDEX is better to use... i have been having problems getting either to work for me... The data looks something like this: A B C D FROM TO CORRECT NEW FROM 60 65 0.4 68 65 70 1.2 73 70 80 -1.5 75 80 110 -1.6 78 what i am trying to do is find which FROM TO range the NEW FROM cells fall within and then add the corresponding CORRECT value to it... Any suggestions would be greatly appreciated! Cheers, Lloydy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I automatically update column index number in VLookup whe. | Excel Worksheet Functions | |||
VLOOKUP, INDEX & MATCH ERROR HELP | Excel Worksheet Functions | |||
Match, Index, Vlookup, Large....Help Please | Excel Worksheet Functions | |||
vlookup change column index position - without changing formulae | Excel Worksheet Functions | |||
Vlookup, Index & Match | Excel Worksheet Functions |