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-com
ffice
ffice" /><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.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
![Eek! :o :o](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f631.png)
![Eek! :o :o](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f631.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
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
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
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
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
If however you can think of a different way of doing it without a macro that’s cool as well.
Thanks for the help.