If equations with Vlookups

[MR_TJC]

Hi all I have three worksheets…one called communications, one called entertainment, and the final one data.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
In the data tab I will have a column that is tagged either communications or entertainment for each row. Without using a macro I am wondering if the following is possible.
<o></o>
To have a If command with a Vlookup in the communications tab that will look at the corresponding line in the data tab and if its entertainment do nothing but if its communications put the corresponding data from the vlookup. And vice versa for the entertainment worksheet if its communications ignore it but if its entertainment complete the vlookup and report.
<o></o>
If however you can think of a different way of doing it without a macro that’s cool as well.

Thanks for the help.

 

[c_m_s_jr]

Sounds like advanced filter might be more what you are looking for. It will move all lines and the fields you choose to the communication sheet and the entertainment sheet based on the column in the data sheet.

However, not knowing the total layout I am not sure you want else, if anything, you have on the communication and entertainment sheets

 

[MR_TJC]

THere is nothing in the other two sheets.

The data tab is data that will be from an external source that will be added too daily. The last column is a if statement to get wether the row is communications or entertainment.

If the line is communications I want the data to go to the communicatiosn worksheet but if its entertainment I want it to go to the entertainment sheet. I want the data to populate the next available line.

WHat we have right now is one worksheet for both e and c that we use the =data( and cell number) for each cell of data we want to copy over.

IE Name, address phone
Name =data(Cell A1)
etc

And then the next line reads
Name =data(cell a2)

so if we split the worksheets we will not be able to use this report from another cell function and hence want to copy the data from the data tab to the correct worksheets. We want to avoid Macros if at all possible.

Sounds like advanced filter might be more what you are looking for. It will move all lines and the fields you choose to the communication sheet and the entertainment sheet based on the column in the data sheet.

However, not knowing the total layout I am not sure you want else, if anything, you have on the communication and entertainment sheets

 

[c_m_s_jr]

If that is the case then advanced filter will do what you want. You can have the data you are filtering placed on another worksheet. Then each day update the filters to pull from the data tab.

If you need help on it you can send me your spreadsheet or read about advanced filter under "help"

THere is nothing in the other two sheets.

The data tab is data that will be from an external source that will be added too daily. The last column is a if statement to get wether the row is communications or entertainment.

If the line is communications I want the data to go to the communicatiosn worksheet but if its entertainment I want it to go to the entertainment sheet. I want the data to populate the next available line.

WHat we have right now is one worksheet for both e and c that we use the =data( and cell number) for each cell of data we want to copy over.

IE Name, address phone
Name =data(Cell A1)
etc

And then the next line reads
Name =data(cell a2)

so if we split the worksheets we will not be able to use this report from another cell function and hence want to copy the data from the data tab to the correct worksheets. We want to avoid Macros if at all possible.