khalid79m
04-02-2008, 03:57 AM
"=IF(ISERROR(VLOOKUP(RC1,Contact_Type_Summary!R1C2:R60000C4,3,FALSE)),0,VLOO KUP(RC1,Contact_Type_Summary!R1C2:R6000C4,3,FALSE))"
this is the vlookup code I have it looks this in excel
=IF(ISERROR(VLOOKUP($A2,Contact_Type_Summary!$B$1:$D$60000,3,FALSE)),0,VLOO KUP($A2,Contact_Type_Summary!$B$1:$D$6000,3,FALSE))
this is checking if a2 has match on sheet Contact_Type_Summary column b1 to d60000 and returning the value in column 3.
the problem I am having is in a2 i have the full name eg
Buisness_Telecoms
but on the Contact_Type_summary it appears like
Buiness_Tele
so the vlookup doesnt work how can i get it to work/?:whip
this is the vlookup code I have it looks this in excel
=IF(ISERROR(VLOOKUP($A2,Contact_Type_Summary!$B$1:$D$60000,3,FALSE)),0,VLOO KUP($A2,Contact_Type_Summary!$B$1:$D$6000,3,FALSE))
this is checking if a2 has match on sheet Contact_Type_Summary column b1 to d60000 and returning the value in column 3.
the problem I am having is in a2 i have the full name eg
Buisness_Telecoms
but on the Contact_Type_summary it appears like
Buiness_Tele
so the vlookup doesnt work how can i get it to work/?:whip