vLOOKUP the Parameter range

%3CLINGO-SUB%20id%3D%22lingo-sub-1460487%22%20slang%3D%22en-US%22%3EvLOOKUP%20the%20Parameter%20range%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1460487%22%20slang%3D%22en-US%22%3E%3CP%3Ehe%26nbsp%3BvLOOKUP%20the%20Parameter%20range%20of%20third%20is%2010%2C%3C%2FP%3E%3CP%3E%3DVLOOKUP(%24C%242%2C'%E7%94%A2%E5%93%81-%E5%93%81%E5%90%8D'!%24C%244%3A%24K%2410000%2C10%2C0)%3C%2FP%3E%3CP%3Ehave%20a%20problem%20%2Cwhy%20not%20.%20when%20I%20key%209%20%2Cno%20problem.%3C%2FP%3E%3CP%3Ewhy%20not%20I%20can't%20read%2010%20column.%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3Bthanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1460487%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1460586%22%20slang%3D%22en-US%22%3ERe%3A%20vLOOKUP%20the%20Parameter%20range%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1460586%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F698318%22%20target%3D%22_blank%22%3E%40jackywang292%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYour%20range%20is%20from%20column%20C%20to%20column%20K%2C%20there%20are%20only%209%20columns%20in%20the%20range.%20%2310%20is%20out%20of%20the%20range%2C%20thus%20an%20error.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

he vLOOKUP the Parameter range of third is 10,

=VLOOKUP($C$2,'產品-品名'!$C$4:$K$10000,10,0)

have a problem ,why not . when I key 9 ,no problem.

why not I can't read 10 column.

     thanks

1 Reply
Highlighted

@jackywang292 

Your range is from column C to column K, there are only 9 columns in the range. #10 is out of the range, thus an error.