Download the source file is as follows:

 
http://www.zj-jinma.com/111/test.xlsx 

I want to find in the table according to the names of the five people to find the "origin", the vlookup grammar, right?

=VLOOKUP (C18, A1: G15, 7, FALSE) 

CodePudding user response:

Results wrong, natural formula is wrong, can try=VLOOKUP (C18, $C $1: $G $15, 5, FALSE)
Asked to query by the key words in the first column; Data area often need to use an absolute address, otherwise a la formula query area changed elsewhere, wrong,

CodePudding user response:

too much! This statement "=VLOOKUP (C18, $C $1: $G $15, 5, FALSE)", true success! There is a very key: ask for keyword in the first column with

Thank you, CSDN heroes really master!