multiple lookup

[prakashkumar]

sir
IF I ENTER CODE {1250} IN CODE CELL THE QTY WILL DISPLAY BY USING SUMIF BUT I WANT LOCATION IN LOCATION CELL AS X Z A D
PLS GIVE SOME HELP.
AS ATTACHED IMAGE

THANKING YOU SIR

 

[Georgiboy]

Waht version of Excel are you using?

 

[kvsrinivasamurthy]

Since your excel version is 2010 Textjoin function is not available. So macro or UDF with code is better . Is it ok?

 

[prakashkumar]

ANY OTHER COMMAND PLS

 

[Peter_SSs]

ANY OTHER COMMAND PLS

You did not answer this question:

macro or UDF with code is better . Is it ok?

 

[Jeyakumar]

Vlookup with lookup value will be concatenate of Code and qty