HotNumbers
Well-known Member
- Joined
- Feb 14, 2005
- Messages
- 732
How do I do a Index Match formula where it looks up a table if it match it returns the match if it doesn't find a match than it return a defualt of "18"
table example below
Excel 2007
table example below
Excel Workbook | ||||
---|---|---|---|---|
A | B | |||
1 | Table | |||
2 | 18 | |||
3 | 26 | |||
4 | 30 | |||
5 | 31 | |||
6 | ||||
7 | ||||
8 | ||||
9 | ||||
10 | ||||
11 | Lookup | Formula | ||
12 | 18 | |||
13 | 26 | |||
14 | 30 | |||
15 | 31 | |||
16 | 26 | |||
17 | 38 | |||
18 | 75 | |||
19 | 85 | |||
Sheet1 |