Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Using If and Vlookup Function Using If and Vlookup Function
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 03-14-2014, 07:56 AM
jassi.mgg@gmail.com jassi.mgg@gmail.com is offline Using If and Vlookup Function Windows 8 Using If and Vlookup Function Office 2007
Novice
Using If and Vlookup Function 		 
Join Date: Mar 2014
Posts: 2
jassi.mgg@gmail.com is on a distinguished road
Default Using If and Vlookup Function
Please help me with this excel file for using If and Vlookup Function together
Attached Files
File Type: xlsx Time Allowed.xlsx (10.6 KB, 17 views)
Reply With Quote
  #2  
Old 03-14-2014, 12:18 PM
gebobs gebobs is offline Using If and Vlookup Function Windows 7 64bit Using If and Vlookup Function Office 2010 64bit
Expert
  
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default
I used Sumproduct instead and sussed the age range data into upper and lower columns. Let me know if you need more explanation.
Attached Files
File Type: xlsx Time Allowed.xlsx (11.4 KB, 20 views)
Reply With Quote
  #3  
Old 03-15-2014, 06:53 AM
jassi.mgg@gmail.com jassi.mgg@gmail.com is offline Using If and Vlookup Function Windows 8 Using If and Vlookup Function Office 2007
Novice
Using If and Vlookup Function 		 
Join Date: Mar 2014
Posts: 2
jassi.mgg@gmail.com is on a distinguished road
Default
Quote:
Originally Posted by gebobs View Post
I used Sumproduct instead and sussed the age range data into upper and lower columns. Let me know if you need more explanation.
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.
Reply With Quote
  #4  
Old 03-15-2014, 07:39 AM
gebobs gebobs is offline Using If and Vlookup Function Windows 7 64bit Using If and Vlookup Function Office 2010 64bit
Expert
  
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default
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?
Reply With Quote
  #5  
Old 03-15-2014, 08:59 AM
Kevin@Radstock Kevin@Radstock is offline Using If and Vlookup Function Windows 8 Using If and Vlookup Function Office 2013
Office 365
  
Join Date: Feb 2012
Posts: 94
Kevin@Radstock is on a distinguished road
Default
If you change the data in the Age Range F4:F8 as the attached, then use the attached IF & VLOOKUP formulas.
Attached Files
File Type: xlsx 004-Time Allowed.xlsx (17.3 KB, 15 views)
Reply With Quote
  #6  
Old 03-16-2014, 01:47 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Using If and Vlookup Function Windows 7 64bit Using If and Vlookup Function Office 2010 64bit
Expert
  
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,919
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default
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
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
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
Using If and Vlookup Function Is this possible using the Vlookup or any other function? Delson Excel 4 02-08-2010 01:27 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:06 PM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft