Posted to microsoft.public.excel.misc

John Gregory John Gregory is offline

external usenet poster

Posts: 22

Multiple If statement

I am trying to write a "IF" test to do the following:

If the value of A1 = 1, then cell = B1
If the value of A1 = 2, then cell = B2
If the value of A1 = 3, then cell = B3

The cell A1 is used as the selector, and I have data that is in each of the
B cells (too much data for a list). I have tried data validation, but could
not get it to work.

Any ideas?

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
Multiple if Statement?	jeffmp21	Excel Discussion (Misc queries)	6	June 5th 08 07:49 PM
Multiple IF statement	Kristen PS	Excel Worksheet Functions	5	May 13th 08 10:05 PM
Multiple IF statement	Nikki	Excel Discussion (Misc queries)	5	February 26th 08 09:50 AM
Multiple IF Statement	John	Excel Worksheet Functions	4	June 9th 07 02:33 PM
Multiple If Statement	TamIam	Excel Worksheet Functions	8	October 18th 06 08:55 PM

All times are GMT +1. The time now is 01:53 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us