Or add qq1608498317 thank you very much

CodePudding user response:

The "orders" is named region is in the formula, the lookup () kind of formula, required keyword in the first column/first line, see you the meaning of the above, in the second column, otherwise will not be back 3; So you should pick up above two columns, after the third parameter from 3 to 2,

CodePudding user response:

reference 1/f, zara's reply:

the "orders" is named region is in the formula, the lookup () kind of formula, required keyword in the first column/first line, see you the meaning of the above, in the second column, otherwise will not be back 3; So you should pick up above two columns, after the third parameter from 3 to 2,

Wrong oh, I'm a table with another table data matching, my key word is E2, or I send the file to you you help me take a look

CodePudding user response:

No,=vlookup (E2, urban area and urban analysis! B: C, 2) can be like that, if another table name right, also can choose the second parameter directly to another table BC two columns of the required range,