Skip to main content

Formula “LOOK UP” For Using Approximate Match Values Sorted Ascending Order In a List

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:
  • 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:
You might like my another blogs:
Labels:

Comments

Post a Comment