Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I need Help!!!!!!
Hello: I have some problems with an excel Worksheet and I would really appreciate your help: Lets say that I have 2 data sheets, in the first one there is data I need to fill in, and in the other there is data stored, date and a value for each different date for example: Date Value 01/02/2005 16.21 02/02/2005 16.25 03/02/2005 16.30 04/02/2005 16.46 And I need de value stored for the corresponding date on the first sheet: I need to get the value for today’s date, for example if I have today’s date on the first sheet on the A1 cell; I need on Cell B1 the current Value for today’s date. (I use =Today() on A1 to show the current date). I don’t know if a made my self clear, my English is not very good, but if you understand what I said please help me. If possible please answer to my email. Thank you and best regards, Rommel Gadea -- RommelGadea ------------------------------------------------------------------------ RommelGadea's Profile: http://www.excelforum.com/member.php...o&userid=25578 View this thread: http://www.excelforum.com/showthread...hreadid=390048 |
#2
|
|||
|
|||
I'm not certain what you are asking, but if I'm reading it right you may
consider using VLOOKUP. "RommelGadea" wrote in message ... Hello: I have some problems with an excel Worksheet and I would really appreciate your help: Lets say that I have 2 data sheets, in the first one there is data I need to fill in, and in the other there is data stored, date and a value for each different date for example: Date Value 01/02/2005 16.21 02/02/2005 16.25 03/02/2005 16.30 04/02/2005 16.46 And I need de value stored for the corresponding date on the first sheet: I need to get the value for today's date, for example if I have today's date on the first sheet on the A1 cell; I need on Cell B1 the current Value for today's date. (I use =Today() on A1 to show the current date). I don't know if a made my self clear, my English is not very good, but if you understand what I said please help me. If possible please answer to my email. Thank you and best regards, Rommel Gadea -- RommelGadea ------------------------------------------------------------------------ RommelGadea's Profile: http://www.excelforum.com/member.php...o&userid=25578 View this thread: http://www.excelforum.com/showthread...hreadid=390048 |
#3
|
|||
|
|||
yes, vlookup will do the trick :)
MPG "Barb Reinhardt" wrote in message ... I'm not certain what you are asking, but if I'm reading it right you may consider using VLOOKUP. "RommelGadea" wrote in message ... Hello: I have some problems with an excel Worksheet and I would really appreciate your help: Lets say that I have 2 data sheets, in the first one there is data I need to fill in, and in the other there is data stored, date and a value for each different date for example: Date Value 01/02/2005 16.21 02/02/2005 16.25 03/02/2005 16.30 04/02/2005 16.46 And I need de value stored for the corresponding date on the first sheet: I need to get the value for today's date, for example if I have today's date on the first sheet on the A1 cell; I need on Cell B1 the current Value for today's date. (I use =Today() on A1 to show the current date). I don't know if a made my self clear, my English is not very good, but if you understand what I said please help me. If possible please answer to my email. Thank you and best regards, Rommel Gadea -- RommelGadea ------------------------------------------------------------------------ RommelGadea's Profile: http://www.excelforum.com/member.php...o&userid=25578 View this thread: http://www.excelforum.com/showthread...hreadid=390048 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|