get Lookup value

[jitendras]

Hi,

kindly help me

if Match DB name from data after match A+,A,B,C,D,E from the data Than get value in front of that in Stock shops i try in example sheet in for your understanding

Example sheet attached for your better understanding

thanks in advance

[JohnTopley]

In H4

=SUMIFS(C:C,A:A,$E$4,B:B,$F4)

Copy down BUT ....

you will need to change highlighted range to match your merged cells: do not use merged cells as they cause many problems as this illustrates

[jitendras]

Hi,

IF Match Coulum A value from coulum E value also same match Coulum B value from coulum F value then that get vaule from C coulume like vlookup & index match i want like this form to you

Example sheet attached what i want from you to all

[JohnTopley]

Did you try it ????? That's what is does.

because column E is MERGED you cannot have a formula to copy down.

[JohnTopley]

See attached ...

[jitendras]

Thanks lot Topley your the best its work

[JohnTopley]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.