• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Pick Up Min Value

karthidhamo

New Member
Hi,

I have an two excel sheet on below.

Below Example :

Sheet A , Sheet B. I would like to pickup the Sheet B MIN value to match with Unique No of Sheet A.

Any Formula/ Syntex Pls
 
karthidhamo
As with Your previous thread,
please, reread Forum Rules
especially part How to get the Best Results at Chandoo.org
then You'll notice - what should You do next?
 
The minimum might be
= MINIFS(value, group, distinct)
and looking something up on the basis of that
= XLOOKUP( MINIFS(value, group, distinct), value, return )

That appears to conform to your question but without seeing the problem and knowing which version of Excel, who knows?
 
karthidhamo
For cell D6 =MINIFS('Sheet 1'!D$2:D$33,'Sheet 1'!B$2:B$33,Sheet2!C6) and copy down.
AND
after that, You should modify those Your Sheet1-data as
B-column should be a letter A, B, C or D
D-column should have numbers
 
HI,

Sorry I didn't get right ans. You can see i applied formula but value come only zero. I copied your queries and tried but no result and even column B & D as per letter & number.

Pl. help to get resolve.
 

Attachments

  • Match.xlsx
    11.1 KB · Views: 3
karthidhamo
As I wrote: You should modify those Your Sheet1-data ...
Have You copy&paste Your data to Sheet1?
There were many ... something ... I didn't start to check what?
But I got these results after modify.
Take care that numbers are numbers
as well as
Contents are single letters.
Screenshot 2020-12-05 at 10.42.22.png

If Your data looks okay, that do not mean that those are correct!

One note:
If You copy&paste formulas
then take care that both sheets has same layout!
Your new files sheet has ... blank ... in D-column.
That is one reason to get zeros ...
 

Attachments

  • Match.xlsx
    11.9 KB · Views: 5
Last edited:
Back
Top