Value based on another value

[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

 

[Niek Otten]

Hi Mike,

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

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Mike]

Thanks Niek, works great!!

Hi Mike,

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

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel


What

 

[Sabine]

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

 

[J.E. McGimpsey]

I believe that MATCH() in Dutch is VERGELIJKEN()

 

[Niek Otten]

Right!

Niek

I believe that MATCH() in Dutch is VERGELIJKEN()

 

[Sabine]

Thank you both!

Sabine

Right!

Niek
(I equivalent