You are here: HomeExcelTutorials

# Double Lookups

## Double Lookups

Price: FREE

I am currently having issues with my brain, and can't figure this out. I need a formula to detect a user selected item, and return a value based on another input item.
A B C D E F G H I J
1 Years 1 2 3 4 Years 1 2 3 4
Depending on the number of years the person has (input in A2), as well as their ranking (input by an X on the above sheet in B2:E2), it should return a value from the table F1:J4, based on where the user put an X in B2:E2. I am aware I can do IF statements, and create a bunch of hidden columns, but I am looking for a more elegant, thought out formula than I can create at the moment

Visit publisher's web-site: Double Lookups

Category and Tags: ExcelTutorials :

## Related Tutorials

### Double Lookups

Free: Yes
Tags: Excel › Functions

Country Product Value
Germany Car 1,500.00
Germany Bike 200.00
Japan Bike 300.00
Japan Van 2,500.00
Japan Car 10,00.00
Based on the above data,i need a formula that can find "Germany" & " Bike" and provide me the value of 200.00.

### Help with Multipe Lookups

Free: Yes
Tags: Excel ›

Anyone know how to do a double hlookup?
For example I have:
Row: 200 200 2001 2001
Row label 1 label 2 label 1 label 2
Row: 23 25 24 27
So its two rows of labels. The top is a year and the second are labels that repeat for each year and then the data is below.
I want to do a lookup onto another table that if its year 200 and the label is Label 1, then it gives me the data below that. And so forth.
Anyone have a clue?

### V & H Lookups

Free: Yes
Tags: Excel ›

I am fairly experienced in using excel but now have a need to use Vertical and/or Lookups. Can anyone suggest a good (free) online tutorial so I can learn how to use them.

### Lookups in VBA

Free: Yes
Tags: Excel › VBA

sheet 1 in 3 columns
1 - Color- Blue
1 - Price - 4
2 - Color - Red
Etc.
on sheet 2 I have
number - Color - Gender - Price
And I want to parse the line . - Blue - Man - 4 in the second row of sheet 2 (etc).
Afterwards sheet 1 will be destroyed so I have to do it with VBA since Formula's will not work. I have to do a double lookup first looking for 1 and then for the different types (Color, Gender,Price)

### Dependent Lookups

Free: Yes
Tags: Excel ›

and I int that good at excel :S
I'm looking for some help on dependent lookups and was wondering if I could get some help.
I have 6 columns
Site Name, Team Leader, Catchment, Area, Process
I have created a data validation drop down of these 6 column headers
I now want to create a dependent drop down that will show the distinct contents of the column I have selected in the first drop down. Presuming that Site Name is in cell A1 and each of the columns has the same amount of rows how would I go about this.

## Related Applications & Scripts

### Double click script (AS 2.0)

Free: No
Tags: Flash › Excel Buttons

The Double click script (as2.0) is, as the name is saying, the script for double click button.

### PJ Double 1 - text effect

Free: No
Tags: Flash › Excel Text Animation

Animate your sentences or words within seconds, simple drag&drop method. Most complete and elaborate customizable text effect extension on the web. Adjust text color, size, spacing, alignment, rotations, scaling, durations, delays, positions, effect directions, transparencies, filters and many many more features with a flip of your finger.

Free: No

1. Copy the preloader to the first frame of your movie and put stop(); in the second frame
2. Put your content in the second frame of the preloader .fla

### Double Pinned Slider

Free: Yes
Tags: JavaScript › Excel MooTools Sliders

A double pinned slider (slider with two knobs , minimum and maximum) using mootools. Unlike most of Slider Components, this component has a selected range marker. The range maker is is executed using a CSS background image, providing an quick and easy way to maodify the range image as per requirements, to indicate the range selected visually

### PJ Double - Text Effect

Free: No
Tags: Flash › Excel Text Effects

PJ Double - text effect from the PJ collection. Drag&drop text effect for Flash CS3 and up.
Most versatile customizable component available, offering a large number of features and several exclusive options and customizations.