Lookup formula

[SURYA2016]

 

[Joe4]

Based on your example, use this formula in cell D13:

=INDEX($A$1:$H$1,SUMPRODUCT(MAX(($A$2:$H$10=D12)*(COLUMN($A$2:$H$10))))-COLUMN($A$1)+1)

Formula gotten from this thread here: Retrieving the Column Header that Corresponds with a Matched Value

 

[Georgiboy]

How about:

=LOOKUP(D12,A2:H10,A1:H1)

 

[Georgiboy]

Hold on, not sure mine works that well with larger numbers?

 

[Georgiboy]

Ignore me, I think I need to re-learn the basic Excel functions

 

[Arts]

Hi all

I was trying the LOOKUP formula as I don't use that often but going by Georgiboy's formula

I had the below (small sample size data) the below formula for me seems to throw up a N/A when I type in 67 but seems to work when I type in 78. (I have put the data in ascending order as I had read this was what was required t do when using LOOKUP)

Would anyone be able to shed any light where this is going wrong if the formula above works on the larger data size

Iay-1	Iay-2
78​	67​
89​	99​
112​	321​
908​	443​

* Had not seen Georgiboy's last post before I posted up, assuming his LOOKUP formula does not give the OP the desired result

 

[Georgiboy]

Yes when I tested it with a couple of numbers it seemed to work fine, I then posted here and tested a bit more and it all went a bit waffy.

 

[Arts]

ok, thanks for confirming