If cell contains highest number return non adjacent cell in the same row

[Nanaia]

I'm trying to find the highest [MAX] number from column D and provide the information from the same row in column B. I know that if the columns were adjacent I would use [ =INDEX(B:B,MATCH(MAX(C:C),C:C,0)) ]. If I change C:C to D:D I get a #DIV/0! error. Columns C and D are a wide range of numbers not in sequential order and Column B is text. Can anyone help me refine my formula - or completely replace it with one that works?

 

[VBE313]

G1 formula =

=FILTER(B1:C9,MAX(A1:A9)=A1:A9)

 

[Fluff]

If you are getting #DIV0! that suggest that you have that error somewhere in col D.

 

[Nanaia]

If you are getting #DIV0! that suggest that you have that error somewhere in col D.

Awesome! Thank you. There's over 10K rows of data and I haven't finished my coffee yet. It hadn't even occured to me there were DIV0 errors in the AVERAGEIFS formulae in that column.

 

[Fluff]

Glad we could help & thanks for the feedback.