Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-14-2015, 12:59 PM
wentworth16238 wentworth16238 is offline using if and nested vlookup Windows 7 64bit using if and nested vlookup Office 2013
Novice
using if and nested vlookup
 
Join Date: Jun 2015
Posts: 4
wentworth16238 is on a distinguished road
Default Vlookup or Index/match

I've tried a few options on this one but can't find the right formula's to give me what I need.

I've included the spreadsheet. I want to be able to put in the Plan: A,B, OR C, then put in the AGE: 18-25, then put it the EE or ES. From this I need to lookup a figure and bring it back.

I'm doing this kind of spreadsheet for 3 states with different figures, but the same plans,age,EE/ES setup.

Any ideas?

see screenshot below

Plan APlan BPlan CAGEEEESEEESEEESEE(Employee Only)18101215253565EE + Spouse19161518314075LTCTable12022182137458521282124435095223424274955105234027305560115244630336165125CHOOSE:INPUT:Plan type:Aj16255233366770135Age25j17EE or ESESj18265836397375145Price/Month#N/A27643942798015528704245858516529764548919017530824851979518531885154103100195329454571091052053310057601151102153410660631211152253511263661271202353611866691331252453712469721391302553813072751451352653913675781511402754014278811571452854114881841631502954215484871691553054316087901751603154416690931811653254517293961871703354617896991931753454718499102199180355481901021052051853654919610510821119037550202108111217195385512081111142232003955221411411722920540553220117120235210415542261201232412154255523212312624722043556238126129253225445572441291322592304555825013213526523546559256135138271240475602621381412772454856126814114428325049562274144147289255505632801471502952605156428615015330126552565292153156307270535
Attached Files
File Type: xlsx Book1.xlsx (14.0 KB, 10 views)
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Nested Countif Function bdavidson22 Excel 0 12-19-2014 12:36 PM
Nested Vlookup Help asluder2000 Excel 2 11-14-2014 11:00 PM
How to setup Nested If statement bigukfan Mail Merge 4 04-30-2014 05:19 AM
Nested vlookup with varable tables! Dave Jones Excel 0 08-30-2012 09:15 AM
using if and nested vlookup Nested IFs JimS378 Excel 7 05-03-2011 08:20 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:07 PM.


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