Index, & Match formula

[HotNumbers]

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 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

Excel 2007

 

[T. Valko]

T. Valko & Akashwani...

You guys the super EXCELERS ... I posted something yesterday that i think i stumped people on the board. If you get a chance can you see if I am out of my mind or there is a solution for what I am looking for. Link Below, from yesterdays post

Any advice would be great....



http://www.mrexcel.com/forum/showthread.php?t=557727

I'm not much of a programmer, sorry!