Need to read formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I was given this formula =VLOOKUP($A9,$A$4:$C$6,3,FALSE) by a friend who was
helping me on a spreadsheet, however I do not understand how the formula
really works, its pulling from s/sheet below.

Comp. % June July August
83,000 126,000 90,800
C0000133 30% 24,900 37,800 27,240
C0000134 60% 49,800 75,600 54,480
C0000274 10% 8,300 12,600 9,080
Total 83,000.00 126,000.00 90,800.00

C0000134 1 49,800 6/15/2005
C0000133 1 24,900 6/15/2005
C0000274 1 8,300 6/15/2005



Many thansk to whome ever can help!
 
Might I suggest that you take the opportunity to look in HELP index for
VLOOKUP.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mapping strings to integers 5
Function to give previous month 7
Need formula to have date in cell B2 rounded to first of next mont 3
Please help with formula (multiple ifs to determine due date) 3
Need (Excel) formula to make Mark sheet with Automatic Grading 15
Excel formula needed 3
Excel 2002: How to make the formula works ? 8
How to use VLookup with a range of numbers? 3

Back
Top