Combining values using IF/Then search
Solved/Closed
Related:
- Combining values using IF/Then search
- Yahoo search history - Guide
- Safe search settings - Guide
- Google.us search - Guide
- Utorrent web search - Download - Torrent downloads
- Youtube search within channel - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Oct 20, 2011 at 10:40 PM
Oct 20, 2011 at 10:40 PM
REMEMBER the sheet 1 and 2 are interconnected regarding age and DOB.
sample data sheet1
Name Age Class
a 7 2
s 6 1
d 10 3
f 5 1
d 10 3
s 6 1
a 7 2
w 8 3
r 9 6
t 10 8
sheet 2
name dob
a 12-Oct-04
s 8-May-05
d 12-Jul-01
f 11-Jun-06
in sheet1 D2 copy this formula
=VLOOKUP(A2,Sheet2!$A$1:$B$5,2,0)
copy D2 down
do you get what you want
sample data sheet1
Name Age Class
a 7 2
s 6 1
d 10 3
f 5 1
d 10 3
s 6 1
a 7 2
w 8 3
r 9 6
t 10 8
sheet 2
name dob
a 12-Oct-04
s 8-May-05
d 12-Jul-01
f 11-Jun-06
in sheet1 D2 copy this formula
=VLOOKUP(A2,Sheet2!$A$1:$B$5,2,0)
copy D2 down
do you get what you want
Oct 21, 2011 at 10:18 AM