# The question of the use of excel

If a 1 b 2

b 2 a 1

c 3 d 4

d 4 e 5

e 5 c 3

how to use vlookup after the achievement of the previous 2 2 The order!! Thank you

but only if the sort sequence to build, sort,

with Vlookup not increase the number Gray Not in order of magnitude.Directly to the copy before 2 after 2 on the line does not it? Now, after 2 is based on the former corresponding to 2, do not need to use VLOOKUP function to sort the data, you can.Vlookup not work, use

VLOOKUP (lookup_value, table_array, col_index_num, range_lookup)

Lookup_value need to find out in the first array of values.Lookup_value for value, or to quote the text string.

Table_array need for One look at the data sheet.Can be used for regional or regional names used, for example, list or database.

If range_lookup to TRUE, then the first table_array out in ascending numerical order must be:…, -2, -1,0,1,2, …,-Z, FALSE, TRUE; Otherwise, the VLOOKUP function can not return the correct values.If range_lookup to FALSE, table_array do not have to be sorted.

Through ” Data “menu” Sort “option” ascending “can be arranged in ascending numerical press.

Table_array the first column of value for the text, numbers or logical values.

Text is not case sensitive.

= VLOOKUP (1, A2:C10, 2) in the A column to find 1 from the same line of column B to return value (2.17)

## Leave a Reply

You must be logged in to post a comment.