<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | ||||||||||||||||||||||||||||||||||||
<colgroup><col></colgroup><tbody> </tbody> |
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody> </tbody> |
Is there another solution if the column of the phone items is not sorted?Assuming that your lookup data is in A1 to B18, and your lookup value of the phone type is in C1, this in C2:
=VLOOKUP(C1,$A$1:$B$18,2,0)
If your locale is in Europe, you'll need semi-colons instead of commas.
The above formula will work irrespective of the column being sorted or not.Is there another solution if the column of the phone items is not sorted?