Forum Discussion
norcalgirl77
Mar 05, 2019Copper Contributor
Match and Index
I need help with my excel spreadsheet. I am trying to use match and index and I cannot seem to get it to work. I have a column with numbers ranging between 1 and 100. I need a second column to look ...
Twifoo
Mar 05, 2019Silver Contributor
The formula in F5 is:
=LOOKUP(E5,
{0,80,90},
{2,1,0})
=LOOKUP(E5,
{0,80,90},
{2,1,0})