Excel 2007 : Searching for values

[fuzail]

Hi
what i would like to do is this
a cloumn would contain a number that the user would enter..
another cell should then search the value correspoding to the entered value in a particular column
here is an example of what i want

Please Login or Register  to view this content.

basically everything in the result colum should come from the list that i would have specified elsewhere that coincides with the row no of the data entered in the data field
i know this can be done using the nested if.. but with lots of values it becomes complicated

i do hope i have been able to explain this properly..
im new at excel .. just learning from the help files and experimenting

[Paul]

Hi Fuzail, and welcome to the forum.

Perhaps this will work for you:

Let's assume your data is laid out as shown, with numbers 1-4 in A1:A4, your Data (10,20,12,34) in B1:B4, and you want the Result(s) in C1:C4.

Let's also assume your lookup list is in H1:H100.

In C1 you could then use the formula:

=INDEX($H$1:$H$100,B1)

You can then fill that down column C as far as necessary. Give that a shot, adjusting the formulas as needed.

[fuzail]

thanks pjoaquin for the welcome

and thanks for teh solution as well.. works like a charm with the necessary modification ..

umm i also have 1 more question,
is it possible to have a cell that holds the current time ? it should update in real time, ie with the system clock..
if such a thing were possible would help a lot since it would save me the hastle or getting the time stamp everytime..

[rwgrietveld]

=NOW()
Cell format: u:mm:ss