|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
Look Ups and Matches, Sorry if current thread exists- Clueless
ABA wrote:
*There may be a thread that exists but I do not understand them.
I am trying to create a formula so every time I type the letter b the
following data automatically comes up. Example
If I type "b" in column 4 Row C2, then Row 4 columns 5:7 would automatically
show up like = b 0.75 $48.75 $19.50 etc in the following columns
next to the letter b.
The same for a, c, d etc...... Basically when I type "b" it will allows
show/display in the columns next to it 0.75 $48.75 $19.50
rating sys hours Labor Material
a 0.5 $32.50 $13.00 $45.50
b 0.75 $48.75 $19.50 $68.25
c 1 $65.00 $26.00 $91.00
IF SOMEONE CAN HELP I WOULD APPRECIATE IT!
http://www.contextures.com/xlFunctions02.html
|