Hello,
I have typed the following in Excel :
=LOOKUP("T",{"M","ta","u","v"})
why is Excel returning M , shouldn't it return "ta" , since "ta" is closest to T ?
=LOOKUP("T",{"X","ta","u","v"})
here Excel is giving me N/A. Shouldn't it return "ta" ?
I have typed the following in Excel :
=LOOKUP("T",{"M","ta","u","v"})
why is Excel returning M , shouldn't it return "ta" , since "ta" is closest to T ?
=LOOKUP("T",{"X","ta","u","v"})
here Excel is giving me N/A. Shouldn't it return "ta" ?