Index and match min to max based on two criterias

Status
Not open for further replies.

mychi11

New Member
Joined
May 11, 2020
Messages
49
Office Version
  1. 2016
Platform
  1. Windows
artrecordsheet210520202.xlsm
CDEFGMVADAE
1CY NO (1)CY NO (2)CY NO (3) WIFE NAMEART NO. AVAILABLE EMBAVAILABLE OCSTRAW BALANCE LOCATION
2        A-1C-1
368 BETTY200522-01 186A-1C-2
4        A-1C-3
52  ALICE200514-022 1A-1C-4
61  AMY200514-01  11A-1C-5
7        A-1C-6
8345ACE200515-012 1A-1C-7
9        A-1C-8
10        A-1C-9
1168 BETTY200522-012 1A-1C-10
12        A-1C-11
131  AMY200514-01   A-1C-12
STORAGE TANK



I was having problem to show the cy no for betty and amy correctly. I will need them to match according to the location in this. I am wondering if anyone could suggest me a formula for column C to E in this case?
 

Some videos you may like

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
50,886
Office Version
  1. 365
Platform
  1. Windows
Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).
 
Status
Not open for further replies.

Watch MrExcel Video

Forum statistics

Threads
1,118,789
Messages
5,574,303
Members
412,586
Latest member
Medhum
Top