Microsoft Office Excel, the LOOKUP function to operate worksheet has two forms. One is a “VECTOR” form and the other is an “ARRAY” form.
Today article, I only talk about a VECTOR form. The formula criteria of vector form looks only in a one-row or one-column range for a value and responses a value from the same position in another one row or one-column that you refer to.
Notify:
Do you find this article useful?
See more another tips:
Today article, I only talk about a VECTOR form. The formula criteria of vector form looks only in a one-row or one-column range for a value and responses a value from the same position in another one row or one-column that you refer to.
Notify:
- This formula only works if the values: number, text, etc…in the first column table have been sorted in ascending order.
- If there are the same data values in the first column, this formula will return the value that match what the value in the lowest cell in the first column as an image shown below.
Do you find this article useful?
Michael Leng is Thai, has a BA in Hotel management from Ramkhamhaeng University. He had worked for some hotels. Currently he works in logistics field, Bangkok, Thailand. Because of loving in English, he has written some his own blogs in English-he really wants any feedback about his English he has posted.
See more another tips:
- Method of Extract the Specified Characters from the End of Text String Content
- How To Extract The Specified Characters From The Left Of The Text String In Active Cell
- Delete Unwanted Characters and or Blank Space From The Left Side Of Contents In Active Cell
- Removes Characters and Blank Space From The Right Side Of Contents In Cell | Xcel-Guru
- Excel Trick Expand Excel Column Width Fit To The Longest Data Entered
- [Ctrl] + [-](minus sign) Excel Shortcut Open Dialog Box Menu of Delete Cells, Row and Column Function
- 4 Cool Ways To “Sum” Values Of Number In An Excel Worksheet – ExcelTip2day
- How To Use AVERAGEIF Formula "Not" Including “0” (Zero) In Range
- [Shift + Space Bar] Excel Tip How To Select The Entire Row of Excel Worksheet
- Function [Home] Excel Keyboard Key | X'cel
- Learn Thai Free Online [LTFO] | Michael Leng
- Just Sing Along Blog | Song Lyrics In English-Thai Language
- Book-Hub | Best Seller Book Review
- [C+] Cell Phone and Accessory Review
- [1English-1Thai] English – Thai Dictionary Learning Blog
Comments
Post a Comment