#1
|
|||
|
|||
Compare & Write
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" 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. |
#2
|
||||
|
||||
Try:
Code:
=IF(ISNA(VLOOKUP("Obi Wan";B4:B500;1;FALSE));"No Match";"My Name") |
#3
|
|||
|
|||
Thank you for your answer. But it is not working like that. I need to see there Darth Vader. I did your code like this:
Code:
=IF(ISNA(VLOOKUP("Darth Vader";B4:B500;1;FALSE));"No Match";"Darth Vader") |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to write VBA in following example | yoyo4 | Excel Programming | 3 | 12-06-2017 12:30 AM |
How to write macro | yoyo4 | Excel Programming | 1 | 11-19-2017 11:43 PM |
write need help and copy write need help on another page auto | wykoems | Word | 2 | 07-25-2013 07:56 AM |
Write Test | dkub | Word VBA | 1 | 07-21-2012 09:01 PM |
Using COMPARE to compare more than two variables | Wyskers | Word | 1 | 12-03-2011 01:37 AM |