If you want to mention the value in formula itself then use the below
formula:-
=INDEX(A:A,MATCH(24,B:B,0))

If you want to set the C1 (24) as input cell then use the below formula:-
=INDEX(A:A,MATCH(C1,B:B,0))

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"Syed Zeeshan Haider" wrote:

Hello Everybody,
I am working in Excel 2003 with two lists, dates and prices in columns A and
B respectively.
I am trying to use IF worksheet function to find if any prices in the prices
column match a certain figure (say $24), if a match is found I want to
return a corresponding date from the adjacent column, i.e. column A.

For example, if I am searching for $24 in prices list and it is found in B37
then I want to return the date from A37.

Is it possible? If yes then how? Despite my years of extensive experience
with Excel, I haven't been able to figure that out.

Thank you,
--
Syed Zeeshan Haider


.