Vlookup with multiple variables
We have a request for a business scenario where there are multiple variables and would like some help building the appropriate IF statements (or best solution).
A fixed budget (5,500) is available for a short educational course that must break even.
Variables would be for several cost items, such as marketing, instructor, materials, room rental, # students and registration fee.
Is this asking too much to have Excel work out various of these variables if only one or two are given.?
If there's a ready-made template that could be used, where some fixed values could be fed in, that might also work.
Cheers, Susan (Canada)
This post shows how it is possible to assign multiple variables with the same value with PHP. This can be useful if initializing multiple variables with the same initial value or if needing to make multiple copies of a value and then manipulate each separately.
Is it possible to use vlookup for 2 criteria? I want to go to another tab in my workbook and lookup the value that meets 2 criteria. in the example below, I need the id# and project id # to match values on the other tab and return the $ value that matches both.
ID # Project ID Amount
How do I set this formula?
I am trying to tell a cell to perform a mathematical function dependant on the information entered. For example:
if b22 is = to 1.25 to 2.49, than multiply d22 by 4.5%
if b22 is = to 2.50 to 3.74 than multiply d22 by 6.5%
and so on all the way up to 9 different scenarios.
to excel and need some help if you would be so kind.
I have attached an example of what I'm looking to do. It's probably simple but I can't
seem to figure it out being so
Related Applications & Scripts
“Explore” simply allows you to explore your big variables like objects or arrays in clean interface. Just include explore.php and use explore() function to get very interactive interface to explore your variable.
With this source code, you’ll explore your variable with a clean interface, even if they’re huge objects or arrays, you’ll easily navigate on the variable structure.
This file is perfect for any situation. Its easy to use, simple to understand, and can do anything you need it to.
First -> Usability
- It can be used in any project since it is both AS2 and AS3 .
- Its a normal preloader meaning it can load your swf.
- But it can also load external jpgs, gifs, pngs, and even swfs.
Second -> Simplicity
- With easy to edit features, and great documentation its extremely easy to use.
- With variables that have intuitive names, its easy to follow.
- Great commenting, and variables are easily spotted.
Lastly -> Perfect for you
- This file has 6 variables that are all about customization to your project.
- Change the color and size easily. Hide the mouse. Follow the mouse.
- And with a great feature to change the speed, or to make it dynamic and speed up as the file progresses
Create user sessions with this easy to use class. Each session is stored in a database and is locked to the current browser and ip address.
Create Session Variables
Access Session Variables
Delete Session Variables
View session data array
You can use this effect in variety of files. For example as a sparkling background, a star-field or even to make a glittering text. Because of its customizable nature, this script can be easily modified to suite your needs.
There are 9 variables that can be easily changed. For example the number of stars that appear, their rotation speed, the graphics etc.
This component is easy to manipulate and all you need to do is to drag n drop the main MovieClip and change some variables to get the effect you want.
This ones a simple image viewer with an actionscript based rotation, the images are being loaded from an xml file with a simple piece of code in it:
It will automatically set the right positions for each photo when you add more. Number of photos is unlimited.
You can change variables such as xspan and yspan to change the radius of the circle movement, and in the thumb mc you can change the images width and height just by changing the w and h variables.