Smerdis13
New Member
- Joined
- Nov 15, 2023
- Messages
- 13
- Office Version
- 2021
- 2019
- Platform
- Windows
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:
Thanks in advance
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