![]() |
#1
|
|||
|
|||
![]() Please help me with this excel file for using If and Vlookup Function together ![]() |
#2
|
|||
|
|||
![]()
I used Sumproduct instead and sussed the age range data into upper and lower columns. Let me know if you need more explanation.
|
#3
|
|||
|
|||
![]()
Thanks for your help. But I have been asked to use if and vlookup function, If you can help me with that I will really appreciate.
|
#4
|
|||
|
|||
![]()
It can be done, but given the way the data tables are set up, the equations will be extremely ugly.
Is this for a class? |
#5
|
|||
|
|||
![]()
If you change the data in the Age Range F4:F8 as the attached, then use the attached IF & VLOOKUP formulas.
|
#6
|
||||
|
||||
![]()
Is this homework?
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Creating a graph for Future Value function (FV function) | bmoody | Excel | 2 | 11-06-2013 10:52 AM |
Using vlookup with the IF function | CSzoke | Excel | 11 | 06-01-2013 10:56 PM |
Vlookup | ibrahimaa | Excel | 8 | 01-03-2012 09:32 PM |
Help with VLOOKUP | sakhtar | Excel | 2 | 07-24-2010 07:39 PM |
![]() |
Delson | Excel | 4 | 02-08-2010 01:27 PM |