answersLogoWhite

0

the match function give you the position and the lookup function gives you a value.

User Avatar

Wiki User

12y ago

What else can I help you with?

Related Questions

What is the purpose of lookup match function in abinitio?

Hi This is Azeem Look up_count function returns the number of matching records in a lookup file


What range lookup in vlookup function that will only find an exact match if the first column of table array do not need to be sorted?

Range Lookup can be TRUE or FALSE. For your question, you would use the FALSE as the range lookup value. If it is FALSE, then it looks for an exact match only and so it is not necessary to have the values sorted. If it does not find an exact match it will return an error. With TRUE, the values must be in order and either an exact match or the next largest value that is less than lookup value is returned.


What is the preferred route in the route lookup process?

The longest match of letmost bits


What is the difference between a match and a duplicate?

A match is something that is similar but a little different. A duplicate is something that is exactly the same.


What function can be used in Excel to find info in rows based on values in a table data?

There are a number of functions that could be used to achieve that. They are all categorised as lookup functions. Included in them would be ones like VLOOKUP, HLOOKUP, LOOKUP, INDEX and MATCH. You could also use the Advanced Filter facility.


Is a look up used in Excel?

Yes. There are 3 main functions for doing lookups. They are LOOKUP, VLOOKUP and HLOOKUP. You can also use a combination of the MATCH and INDEX functions to achieve a lookup.


What is the difference between a casket match and a buried alive match?

the object of a casket match is to lock your opponenet in a casket or coffin whereas in a buried alive match the object is to bury your opponent alive


What function can be used to find the answer located in a vertical table?

A lookup function like VLOOKUP or INDEX/MATCH can be used to find the answer located in a vertical table. VLOOKUP searches for a value in the first column of a table and returns a value in the same row from a specified column, while INDEX/MATCH combination can retrieve a value at the intersection of a certain row and column based on matching criteria.


In WWE SmackDown vs Raw 2010 what is the difference between submission grapple and submission match?

The difference is that submission grapple is a move but submission match is where you have to use submissions tomake your opponent tap.


What is the difference between the Sig Sauer p220 and the P220 match?

According to the Sig website, the 220 match has a longer barrel and adjustable target sights.


Why is it important to match the motherboard socket type with the proccessor socket type?

The match means the difference between a working computer and a computer that is completely destroyed.


What is the difference between a tennis match played as best of 3 sets and one played as best of 5 sets?

In a best of 3 sets tennis match, the player who wins 2 sets first wins the match. In a best of 5 sets match, the player who wins 3 sets first wins the match. The main difference is the number of sets needed to win the match.