Posted to microsoft.public.excel.misc

5F80YZ

external usenet poster

Posts: 7

Complex Look Up

Hi. I desparately need help with this look up function

The look up data is as below

Sheet 1
Column A Column B Column C
26/10/09 25/11/09 1.123
26/11/09 25/12/09 1.654
26/12/09 25/01/09 1.897

Sheet 2
Column A Column B
05/11/09 ________
15/01/09 ________
21/12/09 ________

OK, what I need to do is in Sheet 2, I need to look up for the dates in
column A and get the look up value from Column C is Sheet 1. Can someone
please help me??

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
complex color fill conditions- if statements or complex formula?	lilly8008	Excel Discussion (Misc queries)	1	December 18th 09 04:57 AM
Complex Look up	RobFJ[_3_]	Excel Worksheet Functions	2	November 4th 08 05:55 PM
Complex sum	Greshter	Excel Discussion (Misc queries)	1	March 9th 07 03:34 AM
Complex Index Match Help (or at least complex to me)	Jennifer Reitman	Excel Discussion (Misc queries)	3	August 10th 06 08:51 PM
Complex sum	Greshter	Excel Discussion (Misc queries)	4	July 21st 06 11:41 PM

All times are GMT +1. The time now is 03:52 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us