Microsoft Excel Formula Help

Hello, Thank you for the information provided. Your problem was very simple and I do not think that this is even worth you spending anything. To save both your time and money, I am adding the solution below. Use the below formula instead of your existing lookup function: ===== =IFERROR(VLOOKUP(A2,[[login to view URL]]Sheet1!$A$1:$T$182,6,0),0) ===== The above function will only work in excel 2007 and above. If you are using a lower version, you will ahve to use the IF function along with the isna function instead. Please use the below function in case of excel version 2003 or lower ===== =IF(ISNA(VLOOKUP(A2,[[login to view URL]]Sheet1!$A$1:$T$182,6,0)),0,VLOOKUP(A2,[[login to view URL]]Sheet1!$A$1:$T$182,6,0)) ===== Though I am unable to explain much in this restricted window, I will still add that a lookup fucntion is not appropraite for finding an exact match (as wwas the requirement in your case) which is why use of vlookup, Index, offset, or hlookup can be better alternatives. To give you an overview, I am a Microsoft Certified Trainer (MCP Id: 7531519) in the field of MS Office and Excel and I have been conducting corporate training, and Excel automation development for the past 9+ years. Developing applications and automating Excel is my specialization as well as my area of interest. Please check my latest Excel addin within my portfolio. I will be happy if you consider me for any future requirements that you may have. Please do not hesitate to contact me if you have any questions. Thank you for posting

Dear sir, I've extensive experience Can i any help Microsoft Excel Formula. My success always measure with client's satisfaction. So, i always try to do the best. Please let me know if you have any questions. Sincerely, Hossionsumon

I can provide the right formula in one hour. Fixing of bugs and minor changes are included in the bid without any additional fees.

Lets start. Having a team of Professionals. We provide high quality work with accuracy. Woudl you like to discuss more?

Hi, I have been developing applications in both Access and Excel for 20 years with extensive use of VBA. I have developed several applications for Freelance clients, please see Feedback and examples in Portfolio. I am UK based, a native English speaker, available on Skype and currently on UTC. I am available from 06:00 tomorrow, my time and would aim to finish in about 2 hrs David

Hi, [I HAVE YOUR SOLUTION...] I build robust, strategic business solutions period. We can get this sorted out straight away...(i.e. now if you want).. PEDIGREE / PREVIOUS WORK My pedigree includes these (my own sites and my own developed software): My Excel and Access development site (I also TEACH development): vbafasttrack.com. I recently completed a project to build a Bitcoin trading application, a binomial and trinomial employee stock options model for a mid-tier US investment bank and have an Insto finance and trading background myself. I am also the developer of the following software freelancesniper. Be advised I have my own company doing this stuff and have an institutional IT background. Cheers. SteveP.

I have excellent 10+years of experience in Excel/VBA. Please check my past reviews and ratings. I assure you 100% accurate & quality job. Just 5-10 mins i will be able to answer you . I am sincere,honest and hardworking independent freelancer . I give more importance to the job than $. Please let me know your email id for ease of communication . Thank You. Regards, Rishi

Respected Sir, It is pleasure for me to render my services to you for fixing lookup formula in given two excel sheets. I assure you the quality and timely work. waiting for your positive response thanks Imran

DONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONE

SOLVED IN A SECOND...SOLVED IN A SECOND...SOLVED IN A SECOND...SOLVED IN A SECOND...SOLVED IN A SECOND...SOLVED IN A SECOND...SOLVED IN A SECOND...SOLVED IN A SECOND...SOLVED IN A SECOND...SOLVED IN A SECOND...SOLVED IN A SECOND...SOLVED IN A SECOND...

Dear Sir, I am a senior Engineer and i am willing to help you in making the formula in your excel file work properly. Looking forward to work with you. Best Regards, Moustafa

A proposal has not yet been provided

Im an excel expert and its easy for me ................................................... ...................................................

I can do this for you no problem. I use Excel everyday and fixing formulae is my specialty. Let me know if you're interested.