hard20 pts · first answer countsexcellookups

Approximate lookup on unsorted data

A rate table is not sorted, and someone uses =VLOOKUP(A2,F2:G100,2,TRUE). What happens?

A.Excel quietly sorts the lookup table itself firstB.The formula always returns #N/AC.Results can be wrong with no error shownD.It works as an exact match instead

Discussion 0

Join free to post in the discussion.

Approximate lookup on unsorted data

Discussion 0

Related questions