i'm useing the (&) to collect 4 cells together then it give me a name like :
A1&B1&C1&D1 = NASSER
BUT sometimes i use A1&B1&C1 to give me khaled
while A1&B1 ..... SHOULD GIVE ME A UNIQE
I think the file i attched will show what i mean
i'm useing the (&) to collect 4 cells together then it give me a name like :
A1&B1&C1&D1 = NASSER
BUT sometimes i use A1&B1&C1 to give me khaled
while A1&B1 ..... SHOULD GIVE ME A UNIQE
I think the file i attched will show what i mean
Last edited by nasser; 04-01-2007 at 11:40 AM.
Not sure if this is what your after
=IF(A4="","",$A$2&" "&A4)&IF(B4="","",$B$2&" "&B4)&IF(C4="","",$C$2&" "&C4)&IF(D4="","",$D$2&" "&D4)&IF(E4="","",$E$2&" "&E4)
VBA Noob
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
sorry but it's not working , what i have is a IF and Vlookup from the other sheet
What are you trying to do. Can you explain in more detail
VBA Noob
Prehaps.
=IF(COUNTA(A4:D4)=0,"",IF(ISERROR(VLOOKUP(A4&B4&C4&D4,Data!$A$2:$G$200,7,FALSE)),VLOOKUP(A4&B4&C4,Data!$A$2:$G$200,7,FALSE),VLOOKUP(A4&B4&C4&D4,Data!$A$2:$G$200,7,FALSE)))
Do you need to use BR
VBA Noob
what i try to do is when i write the numbers in the INSU.sheet in the columnOriginally Posted by VBA Noob
A1, B1,C1,D1 it give me the reference in the DESCRIPTION , ...but sometimes i have code numbers contains of 3 cells only like
A1,B1,C1 so since the formula is about A,B,C,D it not read only the 3 cells
u can try my sheet and it may explan more if u deleted the Number 1 in the comment ceel
Hi,
doesn't your formula perform like it should??
If you delete the 1 it then matches the criteria,
I don't understand what you are trying to do..
i'm so sorry i was right a worng number so u and VBA so right it's already correct and don't have to be changedOriginally Posted by davesexcel
I APOLOGISE I WAS SO WRONG
THANKS FOR UR CONCERN AND THANKS FOR UR TIME
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks