I have this formula that give me an occasional TRUE when the value in a cell of Sheet1 Col A matches the value of a cell in Sheet2 Col A.

```
=IF(IFERROR(VLOOKUP(A1,Sheet2!$A:$A,1,0),"")<>"","TRUE","")

```

Is it possible to copy the true response and the value of Col A to Sheet3?

I have this info on sheet 1:

```
ColA          ColB
username1     Datapoint1
username2     Datapoint2

```

On Sheet 2 I have a list of approved usernames. 

If username1 is on sheet 2 Col C on sheet 1 would show TRUE because of my VLOOKUP formula. In an ideal world in addition to showing TRUE it would add a row on sheet3 and insert the values of Col A and Col B.

This would indicate that on sheet 2 Username4 exists, resulting in a TRUE:

![This would indicate that on sheet 2 Username4 exists, resulting in a TRUE ](https://i.stack.imgur.com/gU31T.png)