VBA to Get Output by check relations from Input

[Smerdis13]

Hi Guys,
i know title is confusing so i start with the example:
I Have one Workbook which in "Input" Sheet i input names and Output is for example for one name is:
Row1: "Jack" "Walks" "to Catch" "MAN UNITED" "Tshirt"
Row2: "Jack" "Walks" "to Catch" "BARCELONA" "Tshirt"
How:
1- Input Name in "Input" Sheet then check with Vlookup from "Dictionary" for "Relation = Father" and "Family = Family1"
2-then in "Action" Sheet search only for "Family" in Column A (Type)
3-then for "Relation" Type from "Input" Sheet, search in "Action" sheet in Column J (Main Relation)
4-then for the exact "Target Relation" in Column I in "Action" Sheet and exact "Family" in "Input" sheet in Column I , search in "Relations" Sheet for column E (Target Fav Team)
5-then based on this structure, output will be made:
Sheet "Input".Range C & Sheet "Action".Range B & Sheet "Action".Range D & Sheet "Dictionary".Range D & Sheet "Action".Range H

Row1: "Jack" "Walks" "to Catch" "MAN UNITED" "Tshirt"
Row2: "Jack" "Walks" "to Catch" "BARCELONA" "Tshirt"

Another Example:
IF Input is: "Hannah"

Row1: "Hannah" "Drives" "to Catch" "REAL MADRID" "Tshirt"
Row2: "Hannah" "Runs" "to Buy" "JUVENTUS" "Video"
Row3: "Hannah" "Runs" "to Buy" "ARSENAL" "Video"
Row4: "Hannah" "Runs" "to Buy" "CHELSEA" "Video"

If INPUT is more than one names, Output should in sequence for each name after the other

Excel File:

19.6 KB file on MEGA

mega.nz

Thanks in advance

 

[zero269]

I would recommend using the forums Excel Add-In to share your table data for other to help you better.

XL2BB - Excel Range to BBCode

Excel 'mini-sheet' in messages - XL2BB Although experts prefer to read your description and question instead of working in your actual file to solve your problem, there are times that it is difficult to explain an issue without providing actual...

www.mrexcel.com

best regards,

 

[Smerdis13]

Sure, but since my Excel had 5 sheets, I uploaded sample file in Mega Link

19.6 KB file on MEGA

mega.nz