LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ABA ABA is offline
external usenet poster
 
Posts: 9
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multi thread in Excel Radhakrishna k.v.n.r[_2_] Excel Worksheet Functions 3 October 29th 07 05:07 AM
HELP...CLUELESS... Thad Excel Discussion (Misc queries) 2 February 21st 07 02:20 AM
how do i omit the a list, and it's matches, so neither exists? markcjr Excel Worksheet Functions 3 January 31st 07 01:46 AM
Shared Wb-Thread 2 Jim May Excel Discussion (Misc queries) 0 September 2nd 06 04:24 PM
Yet another Look up thread... mbachurski Excel Discussion (Misc queries) 3 January 26th 06 10:33 PM


All times are GMT +1. The time now is 03:12 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"