ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Really complicated one.... Experts come rescue me! (https://www.excelbanter.com/excel-discussion-misc-queries/446728-really-complicated-one-experts-come-rescue-me.html)

dogie

Really complicated one.... Experts come rescue me!
 
Right.

List A
List B

I need to search list A for "x" [a box somewhere saying 'enter value here']
I need to then search list B for "x"
I then need to display all the results which occur in the search in list A and not in the search in B.

I THEN need to pull data from list A.

So:
Search for: "
List A List B







Needs to display:
+ data from List A
+ data from List B

Help!!


All times are GMT +1. The time now is 01:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com