close

Hi

I have a sheet with the following data

SE 150 Low
SE 180 Med
SE 200 Hi
SSE 160 Low
SSE 175 Med
SSE 220 Hi

I need a combination of Index and match formula to look up the first
column for exact match i.e, Col 1 SE/SSE and column 2 for nearest match
i.e, the number and return the 3rd column

example if i have SE 175 the value i need is Low
ex 2: i have SE 190 the value i need is med
i have SSE 170 the value i need is low

Thanks in advance
Karthik

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()