S
sachinattri
Hey Guys, thank you all for your inputs, its really cool to be a part o
this forum. Very interesting I must say.
I have a formula which does not work for some reason, would you like t
have a look
=IF((len(ab23)=10);(ISNA(VLOOKUP(Ab23;agentlist!$A$2:$A$3646;2;FALSE));"";VLOOKUP(Ab23;agentlist!$A$2:$A$3646;2;FALSE));"no")
Also, I dont want to post an attachment here because I think it woul
take up space even though it is a very small one but definately I wan
to send a file via email to someone to find out a simpler solution t
what I am doing which is
Step 1 - I get Raw data in a text file arranged by A/c nos for 6 teams
Step 2 - I have to match one number in there to pick up a name from
second sheet.
Step 3 - Then I pick up groups separetely to do my analysis.
It might look simple, and it is simple but I think I am taking a muc
longer route than I could. Anyways, the problem above is a part of tha
bigger picture only.
Thank yo
this forum. Very interesting I must say.
I have a formula which does not work for some reason, would you like t
have a look
=IF((len(ab23)=10);(ISNA(VLOOKUP(Ab23;agentlist!$A$2:$A$3646;2;FALSE));"";VLOOKUP(Ab23;agentlist!$A$2:$A$3646;2;FALSE));"no")
Also, I dont want to post an attachment here because I think it woul
take up space even though it is a very small one but definately I wan
to send a file via email to someone to find out a simpler solution t
what I am doing which is
Step 1 - I get Raw data in a text file arranged by A/c nos for 6 teams
Step 2 - I have to match one number in there to pick up a name from
second sheet.
Step 3 - Then I pick up groups separetely to do my analysis.
It might look simple, and it is simple but I think I am taking a muc
longer route than I could. Anyways, the problem above is a part of tha
bigger picture only.
Thank yo