Vlook up to find Minimum value and maximum value if value has duplicate result

Dear all,

I am having a problem to find out unit price of items which has same code but different price. I want to put the maximum value of the unit price and minimum value of the unit price with vlookup at B13 and C13 column.
Search criteria should be based on code at A13. can any one give me perfect vlookup formula.

Attaching file for your reference.

Hi

a first attempt

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Hope it helps

B14:

Formula:

Please Login or Register  to view this content.

C14:

Formula:

Please Login or Register  to view this content.

and drag down ...

Both formulae are array formulae and must be committed with Ctrl-Shift-Enter rather than just pressing Enter.


Regards, TMS

hi canapone

so it cannot be done by vlookup ? Thanks for ur help. it is working. I need one more your help describing the formula you used. could you please help me to describe it ?

Originally Posted by CANAPONE

Hi

a first attempt

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Hope it helps

Hi TMS

it is showing #value!

Originally Posted by TMShucks

B14:

Formula:

Please Login or Register  to view this content.

C14:

Formula:

Please Login or Register  to view this content.

and drag down ...

Both formulae are array formulae and must be committed with Ctrl-Shift-Enter rather than just pressing Enter.


Regards, TMS

it is showing #value!

Because ...

Both formulae are array formulae and must be committed with Ctrl-Shift-Enter rather than just pressing Enter.

Regards, TMS

Hi TMS

done. thanks.