Value based on another value

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Good Morning All,

Using Excel XP.

I have two columns: A & B
In column A I have a wind direction and column B I have the wind speed as
show below,

A B
----------------------
1 SSW 4.9
2 NW 14.9
3 ESE 13.7
4 W 5.7
----------------------
5 14.9

In B5 I have the formula =max(b1:b4) which returns a value of 14.9. What I
would like to do in A5 is have the corresponding wind direction for the
value in B5, which in this case would be NW to show up in A5. A2 Any help
would be very helpful.

Mike
 
Hi Mike,

=INDEX(A1:A4,MATCH(B5,B1:B4,0))

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Hi Niek,

I tried the formula myself, but I get a #NAME error because of MATCH (I had
to substitute the comma's (,) with semicolons (;) . Looking up the help
about the Index formula did't help, either!
I am using Dutch software, could you please deliver the dutch equivalent of
the match formula?

Alvast bedankt!

Sabine
 
Back
Top