Hello Friends,
I'm new here and I have some questions. I will write my all questions under this Thread. I don't wanna create new threads too much.
My first question is : I have a Table and its name : "Projects" and my all information stay there. Those information are coming from another system.
I created new Table. And its name : "Data".
(Please Check also picture)
1.Q- I want to import the names from "Projects" Table to "Data" Table. Of course the names can be changing and their rows also. That's why i wrote that kind of a code. But its not working correct :
Code:
IF(ISNA(VLOOKUP("Obi Wan";'Projects'!B4:B500;1;FALSE));"My Name"
This is the code. Normally there is not "Obi Wan" and it should be no match. But I'm getting "My Name" every single time. That name available or not available.
How can i fix this. Where is my fault. I'm want to compare the names because as i said; their rows are not stable. I cant use directly B5, tomorrow when i re-update the table and the name can be B10.
2.Q I'm unfortunately no any experience about VBA. That's why i want to do this with a code like as above. I need more complex one. I want a code like this. I need a tip :
If name are same (Darth Vader) and start with P1* go jan18 => c and write get total and do then for feb18=>c and Mrz18=>c last total should be on this table for example 3
(their Positions are everytime same. Jan18-c stays everytime under G but projects can be change of course.)
(I used P1* I meant P1.1 and P1.2 etc...)
hope so i could explain myself. If you can't understand because of my English. I will try again.
Thanks for your support.
Best Regards.