I'm looking up a value on column A to columns B & C, returning the answer from coluimn C however, I know tte value appears multiple times in column B but I want it to return the lowest value in column C?
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
vLookup Question
0
Answers
0
This wants an array formula. Enter the formula in the formula bar and confirm with Ctl+Shift+Enter.
=MIN(IF($B$2:$B$6=A2,$C$2:$C$6))