If, return, unless

[Adamd325]

Hey, so i have an issue with some data.
I have two tabs in the same excel.
On TAB 2 in A column, i need it to find data in column I of TAB 1 but only IF a value appears in column F of TAB 1. I also need this to pull only 1 value per cell and not to pull duplicate values if possible.
Does anyone know how this would be done?
As i am trying to automate what is currently a manual task.

 

[Adamd325]

Hey thank you again for the replies
I sat with it today and managed to work it out

Unfortunately the master tab had too much data on it to add more fields to extract. However i have set up a duplicate filter to highlight when new data is added and removed by the automated function so the formula pulls it and removes it and i just have to copy the new fields up once per day

Thank you again for all the help, i could not have resolved without you, up voted everyone

 

[RobP]

youre welcome, glad to be of assistance.

Thanks for the feedback
Rob