Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Look Ups and Matches, Sorry if current thread exists- Clueless
*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! -- ABA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multi thread in Excel | Excel Worksheet Functions | |||
HELP...CLUELESS... | Excel Discussion (Misc queries) | |||
how do i omit the a list, and it's matches, so neither exists? | Excel Worksheet Functions | |||
Shared Wb-Thread 2 | Excel Discussion (Misc queries) | |||
Yet another Look up thread... | Excel Discussion (Misc queries) |