csePixelated
asked on
Excel formula referencing multiple columns between tables.
I have 2 tables each with 2 columns referenced to find an answer and place it on a 3rd table,
sheet1
tid,cid,product,time
120,453,3b5,8:30
130,453,234,8:32
140,30,23,9:00
150,453,3b5,9:01
160,1278,1,9:07
170,30,3b6,9:09
sheet2
cid,product,ran,pri,produc tname
30,23,na,no,"box of rocks"
30,24,no,yes,"bigger box of rocks"
31,gam,no,no,"rare item"
30,3b5,na,no,"box of rocks, the original"
453,234,5,8,"barrel of monkeys"
453,3b6,4,8,"barrel of dirty monkeys"
1278,15,no,no,"soap"
on a 3rd page i would like to have the following
sheet3
tid,cid,productname,ran
120,453, ,
130,453,"barrel of monkeys",5
140,30,"box of rocks",na
150,453,"box of rocks, the original",na
160,1278, ,
170,30, ,
I have tried vlookup but to no avail, what formula would I use here to match the data across the pages?
sheet1
tid,cid,product,time
120,453,3b5,8:30
130,453,234,8:32
140,30,23,9:00
150,453,3b5,9:01
160,1278,1,9:07
170,30,3b6,9:09
sheet2
cid,product,ran,pri,produc
30,23,na,no,"box of rocks"
30,24,no,yes,"bigger box of rocks"
31,gam,no,no,"rare item"
30,3b5,na,no,"box of rocks, the original"
453,234,5,8,"barrel of monkeys"
453,3b6,4,8,"barrel of dirty monkeys"
1278,15,no,no,"soap"
on a 3rd page i would like to have the following
sheet3
tid,cid,productname,ran
120,453, ,
130,453,"barrel of monkeys",5
140,30,"box of rocks",na
150,453,"box of rocks, the original",na
160,1278, ,
170,30, ,
I have tried vlookup but to no avail, what formula would I use here to match the data across the pages?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER