Performing a Lookup with Unsorted Data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Trying to get data from sheet to another

Sheet1 Sheet
Name Birthday Name Birthda
A1 Tom G1 4/3/65 A1 Jane B1 need the date put here from sheet
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 sheet

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
 
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!
==============================================


Trying to get data from sheet to another:

Sheet1 Sheet2
Name Birthday Name Birthday
A1 Tom G1 4/3/65 A1 Jane B1 need the date
put here from sheet 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 sheet 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,
 
Back
Top