Posted to microsoft.public.excel.misc

KimC

external usenet poster

Posts: 52

Lookup and IF functions I think?? Need Help!!!!

Below is a sample of the details I want to display

A B
1 CODE1 DISPLAY1
2 CODE2 DISPLAY2
3 CODE3 DISPLAY3

I want to display the corresponding value in column B in E7 (see below), if
one of the three cells E4:E6 displays that code.

E
4 BLANK CELL
5 CODE2
6 BLANK CELL
7 DISPLAY2

can this be done, and how would it be done??

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
help on lookup functions	Kesqsay	Excel Worksheet Functions	1	November 17th 05 04:23 PM
Lookup Functions	nick	Excel Worksheet Functions	3	October 11th 05 04:02 PM
Lookup functions	Fiona	Excel Discussion (Misc queries)	1	March 7th 05 09:15 AM
Lookup Functions	Sharon	Excel Worksheet Functions	6	February 20th 05 05:04 AM
Lookup Functions	Imran	Excel Worksheet Functions	1	November 5th 04 03:35 PM

All times are GMT +1. The time now is 11:48 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us