Neeru Raasi
About
-
Posted Answers
Answer
First, macro players are willing to invest across multiple sectors and trading In fact, most hedge fund investors have been under-exposed to global macro funds
Answer is posted for the following question.
Answer
The B. Tech biotechnology is an undergraduate engineering course in the spectrum of engineering. Biotechnology engineering is a field of applied biology and chemical engineering principles that involves the use of living things in engineering, technology, medicine, and other useful applications. The B.
Answer is posted for the following question.
What do we study in b tech biotechnology?
Answer
Published November 2009
Some law schools, such as the University of Pennsylvania and the University of Michigan, ask you to write a short statement (in addition to a personal statement) detailing why you wish to attend their school. You should consider this a question you need to answer in all of your applications. It is harder than ever to be accepted to law school, and tailoring each application has become the practice of the most serious candidates. Tailoring your statement helps you connect with the people reading your application. It demonstrates that you want to be part of their program specifically. If you send the same statement to eight schools, you are sending the message that they have to want you and be willing to fight for you. The committee will be more willing to risk accepting you if they think you really want them and that you will be truly thrilled to go there. The committee wants you to give them specific reasons for why you two are a good match. You must use your rhetorical skills to convince them they want and need you in their program. Don’t make them do the work of analyzing why you two would be a good fit. Grab this opportunity for yourself; otherwise, the committee might not expend the mental effort needed to match you to their program. Former dean Robert Berring of UC Berkeley Boalt Hall offers the same advice:
You are essentially marketing yourself to each law school, whether you choose to put a kinder spin on that or not. Business school applicants know they’re marketing themselves; marketing is an important part of their world. Lawyers often call marketing “rhetorical skills,” but they are essentially the same concept: to convince someone else to think what you want them to think, by using gentle psychological manipulation, appeals to certain values, and clear logic.
The more you can find out about each individual program, the better off you’ll be to explain “Why Our School.” There are many ways to find out about a program, and to find a place in that program for yourself. For example, you could read or skim a book that genuinely interests you by one of the law school professors and make a case for why he or she is the one you want to teach you about X. You might email this professor to thank them for their book and perhaps ask them a question about their methodology: “I just finished your book, X, and I wanted to write to let you know that I thoroughly enjoyed it. It made me change the way I think about X. I’ve been thinking about the related problem of Y, and I’m wondering if you might be able to recommend an article or book on this topic.” Do not say to Professor So-and-so you’re applying to law school; keep the focus on him and his work. You could then write in your application that you were so inspired by Professor So-and-so’s book, X, that you struck up an email correspondence, in which you discovered you were both interested in Y, and it would be an honor to have a chance to get to work with this law professor whom you admire. In the course of all this, you probably will get inspired and probably will genuinely be interested in this topic. This is one example of how you might create a valid reason for the admissions committee to accept you. Someone on the committee might even chat with Professor So-and-so, who might encourage the committee member to admit you. You can also discover specific reasons for wanting to attend a particular institution by contacting alumni from that law school (martindale.com is a good internet source for finding attorneys and where they attended law school). Asking an alum for a short informational interview can yield helpful specifics about your preferred school.
Note that even schools without a “Why Our School?” essay will read this type of essay as an addendum. Dean Jason Trujillo of the University of Virginia School of Law confirms this: “Applicants can and do submit ‘Why UVA’ essays all the time. We just do not specifically ask for them.” Dean Trujillo also confides, “I also get a number of “Why X Law School” essays all the time, where X is (accidentally) not Virginia Law. That is a sure way to get yourself wait-listed or rejected.”
Why Penn?
An ideal “Why” essay will show that your knowledge and interest of the school goes far beyond the surface. The following “Why Penn” essay was written by a candidate who was accepted to Penn with just a 3.3 GPA (but a 177 LSAT score). This sample “Why Penn” essay details the applicant’s visit to Penn. It provides strong reasons why Penn is the ideal law school for this candidate, and it assures the Penn admissions committee that this student would attend if admitted (which he did). A well-written “Why Penn” essay can definitely make a difference for borderline applicants. Here is an example of a strong “Why Penn” essay:
“What if those prospectives, up there, fell through the floor? Would Penn have a duty to them that would be different from Penn’s duty to you? They haven’t paid tuition–I bet they haven’t even paid their application fees yet!” That hypothetical, posed by Professor Eric Feldman during a Torts class, drew laughter from the students and eight visitors (including myself) who were present. After the chuckling died down, three students responded to the question seriously (unfortunately, no one seemed to think Penn would have much of a duty to us poor, injured prospectives), and Professor Feldman went on from there to another hypothetical. Throughout class, students were well prepared, and they actively and intelligently participated in the discussion. Both students and professor showed evidence of what I am most looking for in my law school experience: a rigorous, intellectual inquiry into the law that takes place in a collegial, and relatively relaxed, atmosphere. Other students I spoke to and observed that day solidified my impression. So did the conversations I had with my friend, Priya, Penn Law '08. She spoke glowingly about the academic and theoretical foundation she received at Penn and the advantages it gave her during clerkship, in corporate law, and now, in the Philadelphia D.A.’s office. Priya also gave rave reviews to Penn’s professors (Geoffrey Hazard, in particular) and the atmosphere of the school. I have visited schools where students were relaxed and happy, and I have spoken to students at others where the academics were intense and rigorous. Penn Law is the only place I have personally encountered that has all those characteristics simultaneously, and, largely because of that, Penn is my first choice for law school.
Among the many other attractive aspects of Penn is that it demonstrably considers public service as something more than an afterthought. I have heard nothing but positive reviews of the public service requirement, and I am also interested in completing for-credit public service, through an offering such as the Interdisciplinary Child Advocacy Clinic. Penn’s overtly interdisciplinary approach to law is also appealing, since I have practical goals involving cross-disciplinary work. My wife is an Ob/Gyn here in Delaware, which has a developing medical malpractice insurance crisis, and I am interested in supplementing my legal education with courses like “Economics of Health Care and Policy” at Wharton in hopes of one day contributing to a solution.
My wife, and my family in general, represent another major reason why Penn Law would be the ideal place for me to pursue my legal education. We have lived in Boston, New York City, and the Bay Area of California, but Dover, Delaware is where we have made our home. We are deeply involved in the community and have established strong friendships here. My wife has recently become a partner in her medical practice, and would prefer not to start her career over somewhere new. If nothing else, there is one very practical consideration tying us to the area: if my wife were to leave the state, she would be charged a malpractice insurance premium to cover hypothetical lawsuits that could be brought against her regarding any of the deliveries and other surgeries that she has performed here over the past three years. That premium would cost us, personally, over $75,000.
I realize that, if admitted, I would need to find an apartment closer to the school than our home is. But the University of Pennsylvania Law School is the only institution where I can get a top-quality legal education without tearing up the roots we have worked hard to put down during our years in Dover and also avoid putting the family in debt far beyond just the cost of law school. I am truly lucky, therefore, that Penn Law is also the school I am most excited about attending. In fact, if admitted, I wouldn’t even sue if I were to somehow fall through the floor of a lecture hall during one of Professor Feldman’s Torts classes.
Why Michigan?
1. Law in the Casbah
I am applying to the University of Michigan Law School for both academic and personal reasons. First, Michigan offers academic programs that few other law schools have. I plan to pursue a JD/MA with Middle Eastern and North African Studies. Michigan’s program in this field is simply unparalleled. In addition, due to my work with my non-profit organization as well as my own personal experiences, I am interested in studying sexual harassment law in an international setting. There are few legal scholars with an expertise on the rights of sexual assault or harassment victims in a global setting, and fewer still with the knowledge of Catherine MacKinnon. I believe the ability to study with Professor MacKinnon would be an exceptional opportunity to further both my academic and career goals.
I also have personal reasons for my application to the University of Michigan. I am originally from the Midwest, and I would prefer to stay in the region for law school. Moreover, I took the opportunity to visit the law school’s campus and I was thoroughly impressed not only by the quality of students I encountered, but also by the collegiality I saw in the student body. I found the University of Michigan to be a place where brilliant, motivated students pushed themselves to succeed and wanted to see their classmates thrive as well. This is the type of law school environment I hope to experience.
Beyond the opportunities the University of Michigan offers to me, I believe I would add a unique and welcome voice to the school. I had the opportunity to live, work, and study in multiple countries, including Morocco, Jordan, Tanzania, and Korea. Few people take or have such opportunities, and seldom do such people come from rural Iowa. I believe my unique experiences and background would greatly contribute to the diversity of the law school.
2. Taxi!
Having spent the majority of my life in New York City, I am the shameful owner of a state identification card that states in bold capital print: non-driver. As such, accessibility and public transportation are important factors for me in deciding where to attend law school. After speaking with several alumni and a current sociology professor at the University of Michigan, I feel that Ann Arbor is a happy median between being stranded on campus and the bustle of an overcrowded city. Location is only one of several reasons why the University of Michigan Law School is my top choice.
In regards to academics, the Child Advocacy Law Clinic and the Children's Rights Appellate Practice course are of particular interest. The clinic and appellate practice course offer amazing opportunities to gain experience in litigation and even more so the chance to impact a child's life. My interest in child advocacy was piqued during a Child and Family Studies course called Violence in the Family at Stony Brook University; it was taught by a former child advocate. My own history with a less than ideal upbringing also lends to my attraction to the clinic. I believe that my experiences allow me to sympathize and relate with a diverse population, qualities that make me a suitable candidate for the clinic.
There of course the usual reasons why I would like to attend the University of Michigan Law School, such as the impressive history, architectural beauty, and collegial environment. However, it was the summer start program and dual degree option in social work that proved to be the tipping point in my decision to apply as an early decision applicant. The summer start program allows flexible first year class scheduling, the opportunity to take several electives, and time to settle into Ann Arbor. As for the dual degree option in social work, it was refreshing to find that simultaneous acceptance to the master's program in social work and law school is not necessary.
Answer is posted for the following question.
why berkeley law essay?
Answer
Government rules and regulations are notoriously difficult to navigate — dare we say dangerous if a form is filled out incorrectly or mistakes are made when dealing with Uncle Sam.
This causes people and businesses to second guess those rare opportunities and government-funded avenues of support when they do arise.
👉 See If I Prequalify
We saw this with the PPP Loans, and currently, we’re seeing this hesitancy with the Employee Retention Tax Credit (ERTC). The ERTC’s retroactive deadline was January 1, 2022, but it has been pushed back further to October 1, 2021, resulting in qualification changes.
The Coronavirus Aid, Relief, and Economic Security (CARES) Act created ERTC to help businesses keep employees on the payroll. The ERTC gives eligible employers and small to medium size businesses the means to receive up to 50% of qualifying wages paid from March 13th to December 31, 2020.
(Video: The Employee Retention Credit explained and how to know if your business qualifies)
👉 See If I Prequalify
Employers who received a Paycheck Protection Program (PPP) loan are still eligible for the ERTC. The most a company that is granted the ERTC can get is up to $26,000 per employee in the form of a grant.
According to the National Federation of Independent Business (NFIB), only 4% of small business owners are familiar with the ERTC program and many are asking what is ERTC. However, this little-known government aid has massive benefits for businesses.
With employee retention being such a hot topic, the government understands that in order to keep employees around, you’ll still need to be able to pay them. The ERTC serves as a lifeline to help companies and eligible employers and their employees survive the waves of unexpected events that have crashed into them over the last several years.
So how can you capitalize on this government aid? Is there a catch? What are the qualifications?
In this Employee Retention Tax Credit guide, we’ll go over everything (including how to file) you need to know about the ERTC in 2023.
➤ The Employee Retention Credit is a refundable tax credit available to certain businesses that qualify. Based on certain factors such as employee cap and qualified wages, specific business owners are entitled to a percentage of qualified wages an employer pays to employees after March 12, 2020, and prior to January 1, 2021.
➤ To qualify and be an eligible employer you must be able to prove that your business was negatively impacted in one or more of the following ways: Your business experienced a partial or total shutdown during 2020 or 2021 (includes being limited by commerce, inability to travel, or restricted group meetings), or gross receipt reduction (a business may be eligible for one quarter and not another).
👉 See If I Prequalify
➤ To apply for the Employee Retention Tax Credit, employers must complete and file Form 941-X, Adjusted Employer’s Quarterly Federal Tax Return or Claim for Refund, with their quarterly federal tax return. For more information on how to apply for employee retention credit, we recommend talking to ERC Assistant to see if you qualify. You can also take this 60-second quiz to start the ERC application process today.
➤ The Employee Retention Credit sunset date was moved from 12/31/21 to 9/30/2021; however, you can still file retroactively as long as you meet the eligibility requirements.
➤ The ERC is not considered taxable income for employees. This means that employees will not have to pay any additional taxes on wages that are covered by the ERC. For employers, the ERC is treated as a Business Expense, which can be used to offset taxes owed. The ERC is a valuable tax relief measure for employers and employees alike, and it can help to retain key personnel during these difficult times.
👉 See If I Prequalify
➤ In short, yes. Initially, if you took the PPP loan, you couldn’t claim the ERTC. However, the Consolidated Appropriations Act (CAA) passed in December 2020 rectified that, enabling smaller businesses to seize both opportunities as long as they met the eligibility requirements and followed the rules. It’s important to note that businesses cannot claim a payroll expense as both an ERTC wage and a forgivable payroll cost on the PPP forgiveness application.
➤ The Employee Retention Credit is essentially like a reimbursement, which means you can’t spend the money on whatever you might like. However, it’s considered a fully refundable tax credit, so you’re getting up to 50% of $10,000 in wages per quarter for each employee if you are eligible and were adversely affected by the pandemic.
➤ A recovery startup business can still claim the ERC for wages paid following June 30, 2021, and prior to January 1, 2022. You can also claim the ERC for prior quarters by filling the applicable adjusted employment tax return within the appropriate deadlines.
👉 See If I Prequalify
➤ Qualified wages are any wages paid by an eligible employer to an employee after March 12, 2020, and before January 1, 2021. For businesses that have experienced a significant decline in gross receipts or any shutdown due to COVID-19, all wages paid to employees are considered qualified wages. The ERC is a refund in the form of a grant and can return up to $26,000 per employee ($11,000 is the average) depending on wages, health care, and other personnel expenses business owners have already paid. The ERTC is available to all businesses, regardless of size or industry.
➤ No. The ERTC is treated as a reimbursement in the form of employer credits, so it’s as if it’s money the government owes you — like you’re being rewarded for making it through these last several years as a business. It is called a loan, but you never have to pay it back.
➤ ERC is a refund in the form of a grant and can return up to $26,000 per employee ($11,000 is the average) depending on wages, health care expenses, and other personnel costs business owners have already paid through the qualifying period.
👉 See If I Prequalify
➤ The ERTC can be claimed for wages paid after March 12, 2020 and before January 1, 2021 (these dates can and do change, resulting in qualification changes as well). To be eligible, employers must have experienced a full or partial shutdown due to a COVID-19-related mandate, or must have experienced a significant decrease in gross receipts.
➤ According to the most recent information from the IRS, forms that have already been filed should expect to result in a reimbursement somewhere between 6-10 months from the date of filing. For businesses that qualify for the ERTC but may want to receive their reward sooner than six months to one year, may be eligible for a business loan as a form of an ERC advanced payment. This loan is then repaid back once the IRS has successfully confirmed the reward and disbursed funds.
ERC Assistant is an employee retention credit service that offers a streamlined process for onboarding clients and filing claims in as little as 1-2 weeks. ERC Assistant also has a secure Client Portal protecting sensitive information to protect you from ERC fraud or other malicious parties. You can get an initial ERC estimate at no cost, with minimal time invested on the front end.
Lastly, the ERC Assistant team is able to deliver ready-to-file documents for the IRS without involving your payroll company.
Why this service makes it easy to file your employee retention tax credit: ERC Assistant analyzes whether or not your business qualifies for the ERC Program, what amount you should receive, and any additional technical details that might arise in this otherwise complex process. With the experts at ERC Assistant by your side, you don’t have to worry about navigating it by yourself. They will guide you and outline the steps it will take for you to maximize the claim for your business answering any ERC questions you may have.
Where to learn more: ERC Assistant
ERC Today is an employee retention credit service that helps companies evaluate their eligibility, completes a comprehensive analysis of their claim, offers guidance on the claiming process and documentation, gives specific program expertise that a regular CPA or payroll processor might not be well-versed in, and executes a fast and smooth end-to-end process, from eligibility to claiming and receiving refunds.
ERC Today assesses how the PPP loan will factor into your ERC, what the differences between the 2020 and 2021 programs are and how it applies to your business, as well as what the aggregation rules are for larger, multi-state employers and you should interpret multiple states’ executive orders.
Why this service makes it easy to file your employee retention tax credit: With effortless data gathering (including a portal for you to upload your 941 returns, PPP loan documents, and raw payroll data), credit calculation to determine the exact value of the credit you are eligible to receive from the IRS, and help amending returns, ERC Today can walk you through the process from beginning to end. ERC Today has benefited companies of all sizes thanks to their expert services, free consultations, being 100% IRS compliant, minimal upfront costs, and extremely high success rates. There are many examples of companies from various industries benefitting from the ERTC.
Where to learn more: ERC Today
Aprio’s ERC experts are nationally recognized as COVID relief policy thought leaders. Aprio’s team thinks creatively to maximize your benefits within the confines and regulations of the IRS. In addition to the employee retention credit services the company offers, Aprio works with other credits to increase your company’s liquidity.
The team has dedicated ERC advisors on the forefront of educating the public and leading clients towards maximum COVID relief benefits.
Why this service makes it easy to file your employee retention tax credit: Aprio’s dedicated ERC and PPP advisors have worked on both sides of the relief equation, so they understand how to navigate the complexities and follow the rules and regulations. Their team of more than 50 COVID relief program specialists constantly stays up-to-date with the latest news and information coming from the SBA, the Treasury, Congress, and the IRS.
Where to learn more: Aprio
To claim the Employee Retention Credit, employers must complete Form 941, Schedule R. The credit is equal to 50% of the qualifying wages paid to each employee through the end of 2021. To be eligible for the ERC credit, employers must have either experienced a disruption in business operations or a decrease in gross receipts. Additionally, employers must maintain their workforce at pre-pandemic levels.
Essentially all businesses qualify for ERC unlike PPP loans since you don’t have to show a decline in revenues but if you do have a decline the grant is automatic.
👉 See If I Prequalify
The credit is equal to 50% of the qualifying wages paid to eligible employees, up to $10,000 of wages per employee per quarter. To calculate the employee retention credit, first determine the number of eligible employees and the total amount of qualifying wages paid to those employees during the relevant quarter.
Qualifying wages are capped at $10,000 per employee for all quarters, so if an employee was paid more than $10,000 in qualifying wages during a quarter, only $5,000 of those wages will be counted towards the credit.
Once you have determined the total amount of qualifying wages paid, multiply that number by 50% to calculate the employee retention credit. For example, if an employer has 10 eligible employees and pays each employee $10,000 in qualifying wages during a quarter, the employer would be entitled to a credit of $50,000 ($10,000 x 10 employees x 50%).
If you have any questions about how to calculate your employee retention credit, please consult with a qualified tax professional.
The credit is equal to 50% of the qualified wages paid by the employer to its employees. The maximum amount of qualified wages per employee is $10,000, so the maximum credit that an employer can receive is $5,000 per employee.
To be eligible for the credit, an employer must have experienced a significant decline in gross receipts or been required to suspend operations due to a governmental order related to COVID-19.
In addition, the employer must have retained its employees during the relevant period and paid them at least $600 in qualifying wages during that period. Qualifying wages include salary, hourly pay, commissions, and other forms of compensation. The employee retention credit is available for wage payments made from March 13, 2020 through December 31, 2020.
Yes. The Employee Retention Tax Credit (ERTC) applies to wages and benefits disbursed between March 13, 2020, and September 30 or December 31 of 2021; however, companies can still send in applications to receive the ERTC. In fact, companies can do so until April 15, 2024 and get the refund if they are eligible and compliant.
To claim the ERC tax credit, businesses must first file for it with the IRS. Businesses will need to provide basic information about their company and employees, as well as documentation showing that they have been impacted by the pandemic. Start here to begin filing your ERC credit.
The IRS will then review the application and determine whether the business is eligible for the credit. If approved, the credit will be applied to future payroll taxes. For businesses that are struggling to keep their employees, the ERC can provide much-needed financial relief.
To start the ERC credit, employers must file Form 941, Employer’s Quarterly Federal Tax Return. The credit can be claimed for each qualifying quarter from January 1, 2021, through June 30, 2021. For more information on how to start the employee retention credit 2023 application, visit the IRS website or reach out to an Employee Retention Credit service.
👉 See If I Prequalify
The Employee Retention Credit (ERC) is designed to essentially reward and reimburse companies for managing to stay afloat during the pandemic and the general uncertainty that came after it. Because of that, it is a refundable tax credit available for employers who can prove that their business was negatively impacted by partial or total shutdowns during 2020 or 2021 or gross receipt reduction.
According to the IRS, as far as the Employee Retention Credit is concerned, an Eligible Employer includes all members of an aggregated group that are treated as a single employer as stated in the provisions of section 2301(d) of the CARES Act. In layman’s terms, when businesses are controlled by common ownership, the group entities are designated as a single employer and aggregated for ERC purposes. Aggregated companies can be classified as controlled groups if it is a parent-subsidiary controlled group of corporations (a single entity owns 50% or more of all of the entities), a brother-sister controlled group of corporations (when 5 or fewer persons own 80 percent or more of each entity in the group with at least 50 percent voting power), or a combined group of corporations (combinations of parent-subsidiary and brother-sister groups).
All full-time and full-time equivalent employees are eligible for the ERC tax credit at companies with less than 100 full-time employees; however, at companies with more than 100 full-time employees, only wages paid to employees after March 12, 2020 and before January 1, 2021 may be treated as qualified wages. The best thing to do to determine which employees are eligible for the ERC tax credit is to work with an ERC firm here.
Absolutely not, employers are under no obligation to reimburse the Employee Retention Tax Credit (ERTC). This refundable payroll tax credit is issued by the IRS and provides certain businesses with financial assistance for expenses incurred due to Covid-19. To be considered eligible for this beneficial credit, companies must adhere to particular criteria predefined by the Internal Revenue Service and submit evidence of their losses. For most taxpayers, the refundable credit is in excess of the payroll taxes paid in a credit-generating period.
In order to be eligible for the ERC, a company must have been wholly or partially impacted by COVID-19 and demonstrate at least a 50% drop in gross receipts when compared to similar quarters.
As per the IRS, you must log this credit as a reduction in deductible payroll costs. To do so, simply categorize the ERC line item to Payroll Gross Pay in the journal transaction. By taking these steps, you’ll be able to ensure that all of your tax documents are up-to-date and accurate.
Fortunately, there is not a limit for how many employees you can be given credit for; however, it is easier for small businesses to claim the credit simply because of the accounting and logistics that go into the process. This can make working with an outside company that specializes in the ERC tax credit worth considering.
The wage limit for any employee remains consistent at $10,000 per calendar quarter while also increasing their credit rate to 70%. This measure is set in place and has been extremely advantageous for those participating thus far.
👉 See If I Prequalify
👉 See If I Prequalify
Answer is posted for the following question.
Erc start date?
Answer
The amino acid L-theanine is an effective treatment of moderate and severe anxiety and does not cause drowsiness. Green tea is used as a
Answer is posted for the following question.
Why does l-theanine help anxiety?
Answer
The shop -- like the company's first flagship in downtown Los Angeles' Japanese Village -- pays homage to Sanrio's Japanese heritage. From a
Answer is posted for the following question.
What is the best hello kitty store in los angeles?
Answer
Located on Sinhagad Road, it is an area that is growing as a prime residential and commercial destination. nanded City is conveniently located and is easily .
Answer is posted for the following question.
Where is nanded city?
Answer
Zoë Foster Blake sells controlling stake in Go -To Skincare for $89m The former journalist turned author, blogger and 'obnoxious skincare tycoon
Answer is posted for the following question.
Who owns go to skincare?
Answer
Masala Gate Canterbury Indian Takeaway
Canterbury, United Kingdom
Answer is posted for the following question.
Could you share best takeaway in Canterbury?
Answer
Find and compare Inn At Lincoln Park shuttles to or from Chicago O'Hare Airport type of transfer (private car or shared shuttle) to make a quick and easy online
Answer is posted for the following question.
How to get from o'hare to lincoln park?
Answer
The original 'Cottage' was built in 1780, by William Craven, the sixth Baron Craven and was located close to where the Johnny Haynes Stand is now. At the time ."Built: 1780 (as a cottage)"Record attendance: 49,335 (October 1938)"Location: Fulham; London, SW6; England"Architect: Archibald Leitch"Life · Pre-Fulham · The ground as it stands · Riverside Stand
Answer is posted for the following question.
When was craven cottage built?
Answer
- An Absolute Reference can be created by typing a “$” in front of either the row or column of a cell reference.
- We can take this same approach to a set of data by creating Absolute References to the starting and ending cells of the table array.
Answer is posted for the following question.
How to keep vlookup formula constant?