Need advice

**spoof** · 01-06-2007, 08:58 PM

I made a dropping list with numbers, at the red area, from column number one on the table. When I choose number at the dropping list, numbers in columns two and three must appear at green area. How to do that?

**VBA Noob** · 01-06-2007, 09:03 PM

Hi,

Try Vlookup or Match and Index

Vlookup link
http://www.contextures.com/xlFunctions02.html

Match and Index link
http://www.contextures.com/xlFunctio...tml#IndexMatch

Post the file if you need more help

VBA Noob

**spoof** · 01-07-2007, 12:56 PM

It didn't help. Need another advice.

**VBA Noob** · 01-07-2007, 12:57 PM

Post the workbook and I take a look

VBA Noob

**spoof** · 01-07-2007, 01:22 PM

Here...

**VBA Noob** · 01-07-2007, 01:28 PM

Try this

VBA Noob

**spoof** · 01-07-2007, 01:38 PM

Thanx

**VBA Noob** · 01-07-2007, 01:39 PM

No Problem

VBA Noob

**spoof** · 01-07-2007, 02:39 PM

How to make the table invisible?

**VBA Noob** · 01-07-2007, 02:42 PM

Can you hide the columns ??

VBA Noob

**spoof** · 01-07-2007, 02:53 PM

No? Is it possible?

**VBA Noob** · 01-07-2007, 03:00 PM

Yes.

Before you hide the columns you would have to move your 3 criteria out of the Table or alternatively you could hide rows 1 to 22 by selecting them then right click while selected and click hide

VBA Noob

**spoof** · 01-07-2007, 03:07 PM

Well ok! I thought there was more serious way like make it invisible, not just hide column by making it shorter.

**VBA Noob** · 01-07-2007, 04:07 PM

Hi,

Try these formula's

=LOOKUP($D$23,{0,0.9,1.9,2.9,3.9,4.9,5.9,6.9,7.9},{0.011905,0.012288,0.012723,0.013168,0.013623,0.014087,0.014561,0.015044,0.015536})

=LOOKUP(D23,{0,0.9,1.9,2.9,3.9,4.9,5.9,6.9,7.9},{0.285701,0.292165,0.299391,0.306682,0.314036,0.321426,0.328872,0.33635,0.343856})

VBA Noob