Find bigest or lowest value in two column and write it to next

It is hard for me and it is easy for you.
Need help to find lowest or highest value (dependent from boss requirement) from prices supply by parts suppliers and insert it into next available column.
As per test file:
Price cell D6
compare to:
Price cell F6

copy into cell J6 (let say) lowest price for item.

Continue to last available price comparison.
Hope it is clear.
Thank you for help.

=min(D6,F6) and drag down

Thank you both of you, beers on me.
You guys are amazing.
Thank you again.

an alternative, if you wish to check both. In L4 i've created a DV list with 1 and 2 in the dropdown and in J6 the following formula dragged down.=CHOOSE($L$4,MIN(F6,D6),MAX(F6,D6)) now select 1 from the dropdown and you'll see the min, change to 2 and you'll see the max

Work as well but I did it manually - don't know " In L4 i've created a DV list" - what is dv list?

a DV list is a drop down, in whereever you'd like it, say cell L24 press Alt + D + L to open the data validation dialogue box, select List from the drop down, in the input box type 1,2 then clock ok. you'll now have a drop down with 1 or 2 as the options, then use the formula I posted =CHOOSE($L$4,MIN(F6,D6),MAX(F6,D6)) and you'll be able to see either 1 to show the min or 2 to show the max

I got it. DV is what confuse me. Now I know: DV is data validation.
Thank you.
One thing may I ask: Is formula or macro dependent from version of software? Is formula from Excel 2003 will work always on Excel 2010?

not always, there are some formulas introduced at the launch of 2007 which don't work in earlier versions. For instance Countif Sumif and works in all versions, but countifs Sumifs only work in 2007 or later. The formula I passed works all versions.I'm still a novice in VBA so one of the people who know that may answer. There are some other newer ones in 2010

That answer some of my problem.
Thank you.