Number time date (A) (B) (C) number (D) (E)
2013.8.28 8:28:29 22 LVZZ3365 ABCDEF
5 LVZZ3366 2013.8.29 9:28:29 GHIGKL

The effect of the need to achieve:
To find the location of the "form" content, and then to "form" as the parameter using VLOOKUP function find references in the sheet1 A: B in the result, please write A VBA code to the

CodePudding user response:

Using VLOOKUP function is wrong, if you switch to the following, and then to use VLOOKUP function can meet the requirements of you
Form (E) the date (A) time number (B) (C) number (D)
ABCDEF 2013.8.28 8:28:29 22 LVZZ3365
5 LVZZ3366 GHIGKL 2013.8.29 9:28:29
Because return which column values, only your query column itself or the following which the value of the column,