Try to use a if then

[rcirone]

I am trying to get info from one tab to another tab.

I am on sheet2 and try to get column INFO OFF OF SHEET1

=(SHEET1!B:B=SHEET1!G2,SHEET1!A:A) ALL i GET IS #VALUE! ERROR

manager	agent	project	out	reason	hours	Agent2
Duran	Andrew	Inbound	Call Out	FMLA	8	Andrew
Duran	Andrew	Inbound	Call Out	FMLA	8	Constance
Duran	Curtis	Inbound	Call Out	FMLA	8	Curtis
Duran	Constance	Inbound	Late	Tires	0.2	Greg
Duran	Constance	Inbound	Late	Late from Lunch	1.5	Pauline
John	Greg Adkins	Inbound	Late	Late from lunch	0.5	Sara

<tbody>
</tbody>

 

[jsotola]

=(
     SHEET1!B:B=SHEET1!G2,        ...  this compares column B to cell G2  
                                                       (true if value of G2 is found in column B
 
     SHEET1!A:A                           ...  adding this makes it an invalid command
)

i think that you need

=IF( comparison , value if true , value if false)

=IF( SHEET1!B:B=SHEET1!G2, SHEET1!A:A)    ... no "if false" value, which is ok

 

[vds1]

It should be

=IF(Sheet1!B2=Sheet1!G2,Sheet1!A2,"Not Matching")

 

[rcirone]

Help I still can not get it. I am sorry I still do not understand

 

[vds1]

All i understand from your post is that you are trying to find the match between agents and if matched who would be the manager. And the formula i pasted does exactly that.

 

[shyy]

VDS1, that works but his format is different, requires 2 sheets. You can VLOOKUP backwards.

Excel 2010

	A	B	C	D	E	F
1	manager	agent	project	out	reason	hours
2	Duran	Andrew	Inbound	Call Out	FMLA	8
3	Duran	Andrew	Inbound	Call Out	FMLA	8
4	Duran	Curtis	Inbound	Call Out	FMLA	8
5	Duran	Constance	Inbound	Late	Tires	0.2
6	Duran	Constance	Inbound	Late	Late fromLunch	1.5
7	John	GregAdkins	Inbound	Late	Late from lunch	0.5

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Excel 2010

	A	B
1	Agent2
2	Andrew	Duran
3	Constance	Duran
4	Curtis	Duran
5	Greg
6	Pauline
7	Sara

<tbody>
</tbody>

Sheet2​

Worksheet Formulas Cell Formula B2 =IFERROR(VLOOKUP(A2,CHOOSE({1,2},Sheet1!$B$2:B$7,Sheet1!A$2:A$7),2,FALSE),"") B3 =IFERROR(VLOOKUP(A3,CHOOSE({1,2},Sheet1!$B$2:B$7,Sheet1!A$2:A$7),2,FALSE),"") B4 =IFERROR(VLOOKUP(A4,CHOOSE({1,2},Sheet1!$B$2:B$7,Sheet1!A$2:A$7),2,FALSE),"") B5 =IFERROR(VLOOKUP(A5,CHOOSE({1,2},Sheet1!$B$2:B$7,Sheet1!A$2:A$7),2,FALSE),"") B6 =IFERROR(VLOOKUP(A6,CHOOSE({1,2},Sheet1!$B$2:B$7,Sheet1!A$2:A$7),2,FALSE),"") B7 =IFERROR(VLOOKUP(A7,CHOOSE({1,2},Sheet1!$B$2:B$7,Sheet1!A$2:A$7),2,FALSE),"") <tbody> </tbody>

<tbody>
</tbody>

 

[rcirone]

This is what I am trying and it still does not work

=IF(Sheet1!I2=Sheet1!D:D,Sheet1!C:C,"Not Matching")


Agent2 is the field I need as the main name so I can lookup the info A:A to H:H
just try to find is manager.

 

[rcirone]

Thank you all for the help we got with your help