Re: Performing a Lookup with Unsorted Data

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: RagDyer (ragdyer_at_cutoutmsn.com)
Date: 02/06/04 

Date: Thu, 5 Feb 2004 18:21:54 -0800

Format Column B on Sheet2 as a Date.

Enter this in B1:

=VLOOKUP(A1,Sheet1!$A$1:$B$4,2,0)
Adjust your cell references as necessary,
And drag down to copy as needed. 

-- 
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
"Fabien" <flapointe@pragmatech.com> wrote in message
news:5D58E460-4B3B-42E9-A088-860A8229A47C@microsoft.com...
Trying to get data from *** to another:
Sheet1                                                           Sheet2
    Name            Birthday                            Name   Birthday
A1 Tom       G1   4/3/65                         A1  Jane  B1 need the date
put here from *** 1
A2 Jim         G2   1/30/63                       A2  Jim    B2  same here..
A3 Sam       G3   2/12/46                       A3  Sam   B3 same here...
A4 Jane       G4    9/3/75                        A4  Tom   B4 need the date
put here from *** 1
I'm trying to use the string from A1 "Jane" to compare to search the range
sheet1!$A$1:$A$4 and return the value from Sheet1$G$1:$G$4 in the same row.
Any help would be appreciated...
Thanks,
Quantcast