software

Hello

Having a little problem getting this code to work I tired many things
including IF commands amp; VLOOKUP and I either get a N/A or False response from
the codes I have tried. It consists of three columns listed below.

A / B / C

Column A: had random numbers from 1 to 8
Example:
1. 4
2. 5
3. 1
4. 8

Column B: Could have numbers from 17 to 45 being listed
Example:
1. 17
2. 42
3. 25
4. 32

Column C is where I want the result to show either RFA1, RFA2 or UFA
This depends on the two factors:
Example:

If column A =1 (A3) then lookup column B (B3) =25 Then LOOKUP this chart
listed below: 25 = RFA2

17=RFA1
18=RFA1
19=RFA1
20=RFA1
21=RFA1
22=RFA1
23=RFA1
24=RFA1
25=RFA2
26=RFA2
27=RFA2
28=RFA2
29=UFA
30=UFA
31=UFA
32=UFA
33=UFA
34=UFA
35=UFA
36=UFA
37=UFA
38=UFA
39=UFA
40=UFA
41=UFA
42=UFA
43=UFA
44=UFA
45=UFAThe chart above will be listed on a separate page if needed, but I’m
thinking a chart may not be required. Any help would be appreciatedHi!

What's the relation of column A to column B? Are you only interested in
column A values of 1? If so:

=IF(A1=1,IF(ISNUMBER(B1),LOOKUP(B1,{0;17;25;29},{quot; quot;;quot;RFA1quot;;quot;RFA2quot;;quot;UFAquot;}),quot;quot;),quot;quot;)

Biff

quot;Killerquot; gt; wrote in message
...
gt; Hello
gt;
gt; Having a little problem getting this code to work I tired many things
gt; including IF commands amp; VLOOKUP and I either get a N/A or False response
gt; from
gt; the codes I have tried. It consists of three columns listed below.
gt;
gt; A / B / C
gt;
gt; Column A: had random numbers from 1 to 8
gt; Example:
gt; 1. 4
gt; 2. 5
gt; 3. 1
gt; 4. 8
gt;
gt; Column B: Could have numbers from 17 to 45 being listed
gt; Example:
gt; 1. 17
gt; 2. 42
gt; 3. 25
gt; 4. 32
gt;
gt; Column C is where I want the result to show either RFA1, RFA2 or UFA
gt; This depends on the two factors:
gt; Example:
gt;
gt; If column A =1 (A3) then lookup column B (B3) =25 Then LOOKUP this chart
gt; listed below: 25 = RFA2
gt;
gt; 17 = RFA1
gt; 18 = RFA1
gt; 19 = RFA1
gt; 20 = RFA1
gt; 21 = RFA1
gt; 22 = RFA1
gt; 23 = RFA1
gt; 24 = RFA1
gt; 25 = RFA2
gt; 26 = RFA2
gt; 27 = RFA2
gt; 28 = RFA2
gt; 29 = UFA
gt; 30 = UFA
gt; 31 = UFA
gt; 32 = UFA
gt; 33 = UFA
gt; 34 = UFA
gt; 35 = UFA
gt; 36 = UFA
gt; 37 = UFA
gt; 38 = UFA
gt; 39 = UFA
gt; 40 = UFA
gt; 41 = UFA
gt; 42 = UFA
gt; 43 = UFA
gt; 44 = UFA
gt; 45 = UFA
gt;
gt;
gt; The chart above will be listed on a separate page if needed, but I'm
gt; thinking a chart may not be required. Any help would be appreciated
gt;
Actually both columns are required.

Because if column A1 =1 then it should look into column B1 and get the
information from there then look into the chart below. To give the value in
column C117 = RFA1
18 = RFA1
19 = RFA1
20 = RFA1
21 = RFA1
22 = RFA1
23 = RFA1
24 = RFA1
25 = RFA2
26 = RFA2
27 = RFA2
28 = RFA2
29 = UFA
30 = UFA
31 = UFA
32 = UFA
33 = UFA
34 = UFA
35 = UFA
36 = UFA
37 = UFA
38 = UFA
39 = UFA
40 = UFA
41 = UFA
42 = UFA
43 = UFA
44 = UFA
45 = UFA

Thanks for the help Biff

quot;Biffquot; wrote:

gt; Hi!
gt;
gt; What's the relation of column A to column B? Are you only interested in
gt; column A values of 1? If so:
gt;
gt; =IF(A1=1,IF(ISNUMBER(B1),LOOKUP(B1,{0;17;25;29},{quot; quot;;quot;RFA1quot;;quot;RFA2quot;;quot;UFAquot;}),quot;quot;),quot;quot;)
gt;
gt; Biff
gt;
gt; quot;Killerquot; gt; wrote in message
gt; ...
gt; gt; Hello
gt; gt;
gt; gt; Having a little problem getting this code to work I tired many things
gt; gt; including IF commands amp; VLOOKUP and I either get a N/A or False response
gt; gt; from
gt; gt; the codes I have tried. It consists of three columns listed below.
gt; gt;
gt; gt; A / B / C
gt; gt;
gt; gt; Column A: had random numbers from 1 to 8
gt; gt; Example:
gt; gt; 1. 4
gt; gt; 2. 5
gt; gt; 3. 1
gt; gt; 4. 8
gt; gt;
gt; gt; Column B: Could have numbers from 17 to 45 being listed
gt; gt; Example:
gt; gt; 1. 17
gt; gt; 2. 42
gt; gt; 3. 25
gt; gt; 4. 32
gt; gt;
gt; gt; Column C is where I want the result to show either RFA1, RFA2 or UFA
gt; gt; This depends on the two factors:
gt; gt; Example:
gt; gt;
gt; gt; If column A =1 (A3) then lookup column B (B3) =25 Then LOOKUP this chart
gt; gt; listed below: 25 = RFA2
gt; gt;
gt; gt; 17 = RFA1
gt; gt; 18 = RFA1
gt; gt; 19 = RFA1
gt; gt; 20 = RFA1
gt; gt; 21 = RFA1
gt; gt; 22 = RFA1
gt; gt; 23 = RFA1
gt; gt; 24 = RFA1
gt; gt; 25 = RFA2
gt; gt; 26 = RFA2
gt; gt; 27 = RFA2
gt; gt; 28 = RFA2
gt; gt; 29 = UFA
gt; gt; 30 = UFA
gt; gt; 31 = UFA
gt; gt; 32 = UFA
gt; gt; 33 = UFA
gt; gt; 34 = UFA
gt; gt; 35 = UFA
gt; gt; 36 = UFA
gt; gt; 37 = UFA
gt; gt; 38 = UFA
gt; gt; 39 = UFA
gt; gt; 40 = UFA
gt; gt; 41 = UFA
gt; gt; 42 = UFA
gt; gt; 43 = UFA
gt; gt; 44 = UFA
gt; gt; 45 = UFA
gt; gt;
gt; gt;
gt; gt; The chart above will be listed on a separate page if needed, but I'm
gt; gt; thinking a chart may not be required. Any help would be appreciated
gt; gt;
gt;
gt;
gt;

Ok I tried that code and it seems to work great but there’s one little
problem it only works a blank worksheet but not the sheet that I have all my
data. The data sheet it’s not listing anything leaving it blank. What could
that be?quot;Killerquot; wrote:

gt; Actually both columns are required.
gt;
gt; Because if column A1 =1 then it should look into column B1 and get the
gt; information from there then look into the chart below. To give the value in
gt; column C1
gt;
gt;
gt; 17 = RFA1
gt; 18 = RFA1
gt; 19 = RFA1
gt; 20 = RFA1
gt; 21 = RFA1
gt; 22 = RFA1
gt; 23 = RFA1
gt; 24 = RFA1
gt; 25 = RFA2
gt; 26 = RFA2
gt; 27 = RFA2
gt; 28 = RFA2
gt; 29 = UFA
gt; 30 = UFA
gt; 31 = UFA
gt; 32 = UFA
gt; 33 = UFA
gt; 34 = UFA
gt; 35 = UFA
gt; 36 = UFA
gt; 37 = UFA
gt; 38 = UFA
gt; 39 = UFA
gt; 40 = UFA
gt; 41 = UFA
gt; 42 = UFA
gt; 43 = UFA
gt; 44 = UFA
gt; 45 = UFA
gt;
gt; Thanks for the help Biff
gt;
gt; quot;Biffquot; wrote:
gt;
gt; gt; Hi!
gt; gt;
gt; gt; What's the relation of column A to column B? Are you only interested in
gt; gt; column A values of 1? If so:
gt; gt;
gt; gt; =IF(A1=1,IF(ISNUMBER(B1),LOOKUP(B1,{0;17;25;29},{quot; quot;;quot;RFA1quot;;quot;RFA2quot;;quot;UFAquot;}),quot;quot;),quot;quot;)
gt; gt;
gt; gt; Biff
gt; gt;
gt; gt; quot;Killerquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; Hello
gt; gt; gt;
gt; gt; gt; Having a little problem getting this code to work I tired many things
gt; gt; gt; including IF commands amp; VLOOKUP and I either get a N/A or False response
gt; gt; gt; from
gt; gt; gt; the codes I have tried. It consists of three columns listed below.
gt; gt; gt;
gt; gt; gt; A / B / C
gt; gt; gt;
gt; gt; gt; Column A: had random numbers from 1 to 8
gt; gt; gt; Example:
gt; gt; gt; 1. 4
gt; gt; gt; 2. 5
gt; gt; gt; 3. 1
gt; gt; gt; 4. 8
gt; gt; gt;
gt; gt; gt; Column B: Could have numbers from 17 to 45 being listed
gt; gt; gt; Example:
gt; gt; gt; 1. 17
gt; gt; gt; 2. 42
gt; gt; gt; 3. 25
gt; gt; gt; 4. 32
gt; gt; gt;
gt; gt; gt; Column C is where I want the result to show either RFA1, RFA2 or UFA
gt; gt; gt; This depends on the two factors:
gt; gt; gt; Example:
gt; gt; gt;
gt; gt; gt; If column A =1 (A3) then lookup column B (B3) =25 Then LOOKUP this chart
gt; gt; gt; listed below: 25 = RFA2
gt; gt; gt;
gt; gt; gt; 17 = RFA1
gt; gt; gt; 18 = RFA1
gt; gt; gt; 19 = RFA1
gt; gt; gt; 20 = RFA1
gt; gt; gt; 21 = RFA1
gt; gt; gt; 22 = RFA1
gt; gt; gt; 23 = RFA1
gt; gt; gt; 24 = RFA1
gt; gt; gt; 25 = RFA2
gt; gt; gt; 26 = RFA2
gt; gt; gt; 27 = RFA2
gt; gt; gt; 28 = RFA2
gt; gt; gt; 29 = UFA
gt; gt; gt; 30 = UFA
gt; gt; gt; 31 = UFA
gt; gt; gt; 32 = UFA
gt; gt; gt; 33 = UFA
gt; gt; gt; 34 = UFA
gt; gt; gt; 35 = UFA
gt; gt; gt; 36 = UFA
gt; gt; gt; 37 = UFA
gt; gt; gt; 38 = UFA
gt; gt; gt; 39 = UFA
gt; gt; gt; 40 = UFA
gt; gt; gt; 41 = UFA
gt; gt; gt; 42 = UFA
gt; gt; gt; 43 = UFA
gt; gt; gt; 44 = UFA
gt; gt; gt; 45 = UFA
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; The chart above will be listed on a separate page if needed, but I'm
gt; gt; gt; thinking a chart may not be required. Any help would be appreciated
gt; gt; gt;
gt; gt;
gt; gt;
gt; gt;

Ok, I'm not understanding this!

gt;gt; Actually both columns are required.

How? What is the relation?

Based on you posted sample:

A...........B..........C
4...........17
5...........42
1...........25
8...........32

What results would you expect in column C?

Biff

quot;Killerquot; gt; wrote in message
...
gt; Ok I tried that code and it seems to work great but there's one little
gt; problem it only works a blank worksheet but not the sheet that I have all
gt; my
gt; data. The data sheet it's not listing anything leaving it blank. What
gt; could
gt; that be?
gt;
gt;
gt; quot;Killerquot; wrote:
gt;
gt;gt; Actually both columns are required.
gt;gt;
gt;gt; Because if column A1 =1 then it should look into column B1 and get the
gt;gt; information from there then look into the chart below. To give the value
gt;gt; in
gt;gt; column C1
gt;gt;
gt;gt;
gt;gt; 17 = RFA1
gt;gt; 18 = RFA1
gt;gt; 19 = RFA1
gt;gt; 20 = RFA1
gt;gt; 21 = RFA1
gt;gt; 22 = RFA1
gt;gt; 23 = RFA1
gt;gt; 24 = RFA1
gt;gt; 25 = RFA2
gt;gt; 26 = RFA2
gt;gt; 27 = RFA2
gt;gt; 28 = RFA2
gt;gt; 29 = UFA
gt;gt; 30 = UFA
gt;gt; 31 = UFA
gt;gt; 32 = UFA
gt;gt; 33 = UFA
gt;gt; 34 = UFA
gt;gt; 35 = UFA
gt;gt; 36 = UFA
gt;gt; 37 = UFA
gt;gt; 38 = UFA
gt;gt; 39 = UFA
gt;gt; 40 = UFA
gt;gt; 41 = UFA
gt;gt; 42 = UFA
gt;gt; 43 = UFA
gt;gt; 44 = UFA
gt;gt; 45 = UFA
gt;gt;
gt;gt; Thanks for the help Biff
gt;gt;
gt;gt; quot;Biffquot; wrote:
gt;gt;
gt;gt; gt; Hi!
gt;gt; gt;
gt;gt; gt; What's the relation of column A to column B? Are you only interested in
gt;gt; gt; column A values of 1? If so:
gt;gt; gt;
gt;gt; gt; =IF(A1=1,IF(ISNUMBER(B1),LOOKUP(B1,{0;17;25;29},{quot; quot;;quot;RFA1quot;;quot;RFA2quot;;quot;UFAquot;}),quot;quot;),quot;quot;)
gt;gt; gt;
gt;gt; gt; Biff
gt;gt; gt;
gt;gt; gt; quot;Killerquot; gt; wrote in message
gt;gt; gt; ...
gt;gt; gt; gt; Hello
gt;gt; gt; gt;
gt;gt; gt; gt; Having a little problem getting this code to work I tired many things
gt;gt; gt; gt; including IF commands amp; VLOOKUP and I either get a N/A or False
gt;gt; gt; gt; response
gt;gt; gt; gt; from
gt;gt; gt; gt; the codes I have tried. It consists of three columns listed below.
gt;gt; gt; gt;
gt;gt; gt; gt; A / B / C
gt;gt; gt; gt;
gt;gt; gt; gt; Column A: had random numbers from 1 to 8
gt;gt; gt; gt; Example:
gt;gt; gt; gt; 1. 4
gt;gt; gt; gt; 2. 5
gt;gt; gt; gt; 3. 1
gt;gt; gt; gt; 4. 8
gt;gt; gt; gt;
gt;gt; gt; gt; Column B: Could have numbers from 17 to 45 being listed
gt;gt; gt; gt; Example:
gt;gt; gt; gt; 1. 17
gt;gt; gt; gt; 2. 42
gt;gt; gt; gt; 3. 25
gt;gt; gt; gt; 4. 32
gt;gt; gt; gt;
gt;gt; gt; gt; Column C is where I want the result to show either RFA1, RFA2 or UFA
gt;gt; gt; gt; This depends on the two factors:
gt;gt; gt; gt; Example:
gt;gt; gt; gt;
gt;gt; gt; gt; If column A =1 (A3) then lookup column B (B3) =25 Then LOOKUP this
gt;gt; gt; gt; chart
gt;gt; gt; gt; listed below: 25 = RFA2
gt;gt; gt; gt;
gt;gt; gt; gt; 17 = RFA1
gt;gt; gt; gt; 18 = RFA1
gt;gt; gt; gt; 19 = RFA1
gt;gt; gt; gt; 20 = RFA1
gt;gt; gt; gt; 21 = RFA1
gt;gt; gt; gt; 22 = RFA1
gt;gt; gt; gt; 23 = RFA1
gt;gt; gt; gt; 24 = RFA1
gt;gt; gt; gt; 25 = RFA2
gt;gt; gt; gt; 26 = RFA2
gt;gt; gt; gt; 27 = RFA2
gt;gt; gt; gt; 28 = RFA2
gt;gt; gt; gt; 29 = UFA
gt;gt; gt; gt; 30 = UFA
gt;gt; gt; gt; 31 = UFA
gt;gt; gt; gt; 32 = UFA
gt;gt; gt; gt; 33 = UFA
gt;gt; gt; gt; 34 = UFA
gt;gt; gt; gt; 35 = UFA
gt;gt; gt; gt; 36 = UFA
gt;gt; gt; gt; 37 = UFA
gt;gt; gt; gt; 38 = UFA
gt;gt; gt; gt; 39 = UFA
gt;gt; gt; gt; 40 = UFA
gt;gt; gt; gt; 41 = UFA
gt;gt; gt; gt; 42 = UFA
gt;gt; gt; gt; 43 = UFA
gt;gt; gt; gt; 44 = UFA
gt;gt; gt; gt; 45 = UFA
gt;gt; gt; gt;
gt;gt; gt; gt;
gt;gt; gt; gt; The chart above will be listed on a separate page if needed, but I'm
gt;gt; gt; gt; thinking a chart may not be required. Any help would be appreciated
gt;gt; gt; gt;
gt;gt; gt;
gt;gt; gt;
gt;gt; gt;
The code you posted first works fine Biff Thanks... Just for some strange
season it's not showing anything if I add the code to a data sheet I have
created but works fine if I create a new sheet... Weird I must say.quot;Biffquot; wrote:

gt; Ok, I'm not understanding this!
gt;
gt; gt;gt; Actually both columns are required.
gt;
gt; How? What is the relation?
gt;
gt; Based on you posted sample:
gt;
gt; A...........B..........C
gt; 4...........17
gt; 5...........42
gt; 1...........25
gt; 8...........32
gt;
gt; What results would you expect in column C?
gt;
gt; Biff
gt;
gt; quot;Killerquot; gt; wrote in message
gt; ...
gt; gt; Ok I tried that code and it seems to work great but there's one little
gt; gt; problem it only works a blank worksheet but not the sheet that I have all
gt; gt; my
gt; gt; data. The data sheet it's not listing anything leaving it blank. What
gt; gt; could
gt; gt; that be?
gt; gt;
gt; gt;
gt; gt; quot;Killerquot; wrote:
gt; gt;
gt; gt;gt; Actually both columns are required.
gt; gt;gt;
gt; gt;gt; Because if column A1 =1 then it should look into column B1 and get the
gt; gt;gt; information from there then look into the chart below. To give the value
gt; gt;gt; in
gt; gt;gt; column C1
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; 17 = RFA1
gt; gt;gt; 18 = RFA1
gt; gt;gt; 19 = RFA1
gt; gt;gt; 20 = RFA1
gt; gt;gt; 21 = RFA1
gt; gt;gt; 22 = RFA1
gt; gt;gt; 23 = RFA1
gt; gt;gt; 24 = RFA1
gt; gt;gt; 25 = RFA2
gt; gt;gt; 26 = RFA2
gt; gt;gt; 27 = RFA2
gt; gt;gt; 28 = RFA2
gt; gt;gt; 29 = UFA
gt; gt;gt; 30 = UFA
gt; gt;gt; 31 = UFA
gt; gt;gt; 32 = UFA
gt; gt;gt; 33 = UFA
gt; gt;gt; 34 = UFA
gt; gt;gt; 35 = UFA
gt; gt;gt; 36 = UFA
gt; gt;gt; 37 = UFA
gt; gt;gt; 38 = UFA
gt; gt;gt; 39 = UFA
gt; gt;gt; 40 = UFA
gt; gt;gt; 41 = UFA
gt; gt;gt; 42 = UFA
gt; gt;gt; 43 = UFA
gt; gt;gt; 44 = UFA
gt; gt;gt; 45 = UFA
gt; gt;gt;
gt; gt;gt; Thanks for the help Biff
gt; gt;gt;
gt; gt;gt; quot;Biffquot; wrote:
gt; gt;gt;
gt; gt;gt; gt; Hi!
gt; gt;gt; gt;
gt; gt;gt; gt; What's the relation of column A to column B? Are you only interested in
gt; gt;gt; gt; column A values of 1? If so:
gt; gt;gt; gt;
gt; gt;gt; gt; =IF(A1=1,IF(ISNUMBER(B1),LOOKUP(B1,{0;17;25;29},{quot; quot;;quot;RFA1quot;;quot;RFA2quot;;quot;UFAquot;}),quot;quot;),quot;quot;)
gt; gt;gt; gt;
gt; gt;gt; gt; Biff
gt; gt;gt; gt;
gt; gt;gt; gt; quot;Killerquot; gt; wrote in message
gt; gt;gt; gt; ...
gt; gt;gt; gt; gt; Hello
gt; gt;gt; gt; gt;
gt; gt;gt; gt; gt; Having a little problem getting this code to work I tired many things
gt; gt;gt; gt; gt; including IF commands amp; VLOOKUP and I either get a N/A or False
gt; gt;gt; gt; gt; response
gt; gt;gt; gt; gt; from
gt; gt;gt; gt; gt; the codes I have tried. It consists of three columns listed below.
gt; gt;gt; gt; gt;
gt; gt;gt; gt; gt; A / B / C
gt; gt;gt; gt; gt;
gt; gt;gt; gt; gt; Column A: had random numbers from 1 to 8
gt; gt;gt; gt; gt; Example:
gt; gt;gt; gt; gt; 1. 4
gt; gt;gt; gt; gt; 2. 5
gt; gt;gt; gt; gt; 3. 1
gt; gt;gt; gt; gt; 4. 8
gt; gt;gt; gt; gt;
gt; gt;gt; gt; gt; Column B: Could have numbers from 17 to 45 being listed
gt; gt;gt; gt; gt; Example:
gt; gt;gt; gt; gt; 1. 17
gt; gt;gt; gt; gt; 2. 42
gt; gt;gt; gt; gt; 3. 25
gt; gt;gt; gt; gt; 4. 32
gt; gt;gt; gt; gt;
gt; gt;gt; gt; gt; Column C is where I want the result to show either RFA1, RFA2 or UFA
gt; gt;gt; gt; gt; This depends on the two factors:
gt; gt;gt; gt; gt; Example:
gt; gt;gt; gt; gt;
gt; gt;gt; gt; gt; If column A =1 (A3) then lookup column B (B3) =25 Then LOOKUP this
gt; gt;gt; gt; gt; chart
gt; gt;gt; gt; gt; listed below: 25 = RFA2
gt; gt;gt; gt; gt;
gt; gt;gt; gt; gt; 17 = RFA1
gt; gt;gt; gt; gt; 18 = RFA1
gt; gt;gt; gt; gt; 19 = RFA1
gt; gt;gt; gt; gt; 20 = RFA1
gt; gt;gt; gt; gt; 21 = RFA1
gt; gt;gt; gt; gt; 22 = RFA1
gt; gt;gt; gt; gt; 23 = RFA1
gt; gt;gt; gt; gt; 24 = RFA1
gt; gt;gt; gt; gt; 25 = RFA2
gt; gt;gt; gt; gt; 26 = RFA2
gt; gt;gt; gt; gt; 27 = RFA2
gt; gt;gt; gt; gt; 28 = RFA2
gt; gt;gt; gt; gt; 29 = UFA
gt; gt;gt; gt; gt; 30 = UFA
gt; gt;gt; gt; gt; 31 = UFA
gt; gt;gt; gt; gt; 32 = UFA
gt; gt;gt; gt; gt; 33 = UFA
gt; gt;gt; gt; gt; 34 = UFA
gt; gt;gt; gt; gt; 35 = UFA
gt; gt;gt; gt; gt; 36 = UFA
gt; gt;gt; gt; gt; 37 = UFA
gt; gt;gt; gt; gt; 38 = UFA
gt; gt;gt; gt; gt; 39 = UFA
gt; gt;gt; gt; gt; 40 = UFA
gt; gt;gt; gt; gt; 41 = UFA
gt; gt;gt; gt; gt; 42 = UFA
gt; gt;gt; gt; gt; 43 = UFA
gt; gt;gt; gt; gt; 44 = UFA
gt; gt;gt; gt; gt; 45 = UFA
gt; gt;gt; gt; gt;
gt; gt;gt; gt; gt;
gt; gt;gt; gt; gt; The chart above will be listed on a separate page if needed, but I'm
gt; gt;gt; gt; gt; thinking a chart may not be required. Any help would be appreciated
gt; gt;gt; gt; gt;
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt; gt;
gt;
gt;
gt;

I'll bet your quot;numbersquot; are not *true* XL numbers, but perhaps numeric text.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
quot;Killerquot; gt; wrote in message
...
gt; The code you posted first works fine Biff Thanks... Just for some strange
gt; season it's not showing anything if I add the code to a data sheet I have
gt; created but works fine if I create a new sheet... Weird I must say.
gt;
gt;
gt; quot;Biffquot; wrote:
gt;
gt; gt; Ok, I'm not understanding this!
gt; gt;
gt; gt; gt;gt; Actually both columns are required.
gt; gt;
gt; gt; How? What is the relation?
gt; gt;
gt; gt; Based on you posted sample:
gt; gt;
gt; gt; A...........B..........C
gt; gt; 4...........17
gt; gt; 5...........42
gt; gt; 1...........25
gt; gt; 8...........32
gt; gt;
gt; gt; What results would you expect in column C?
gt; gt;
gt; gt; Biff
gt; gt;
gt; gt; quot;Killerquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; Ok I tried that code and it seems to work great but there's one little
gt; gt; gt; problem it only works a blank worksheet but not the sheet that I have
all
gt; gt; gt; my
gt; gt; gt; data. The data sheet it's not listing anything leaving it blank. What
gt; gt; gt; could
gt; gt; gt; that be?
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;Killerquot; wrote:
gt; gt; gt;
gt; gt; gt;gt; Actually both columns are required.
gt; gt; gt;gt;
gt; gt; gt;gt; Because if column A1 =1 then it should look into column B1 and get
the
gt; gt; gt;gt; information from there then look into the chart below. To give the
value
gt; gt; gt;gt; in
gt; gt; gt;gt; column C1
gt; gt; gt;gt;
gt; gt; gt;gt;
gt; gt; gt;gt; 17 = RFA1
gt; gt; gt;gt; 18 = RFA1
gt; gt; gt;gt; 19 = RFA1
gt; gt; gt;gt; 20 = RFA1
gt; gt; gt;gt; 21 = RFA1
gt; gt; gt;gt; 22 = RFA1
gt; gt; gt;gt; 23 = RFA1
gt; gt; gt;gt; 24 = RFA1
gt; gt; gt;gt; 25 = RFA2
gt; gt; gt;gt; 26 = RFA2
gt; gt; gt;gt; 27 = RFA2
gt; gt; gt;gt; 28 = RFA2
gt; gt; gt;gt; 29 = UFA
gt; gt; gt;gt; 30 = UFA
gt; gt; gt;gt; 31 = UFA
gt; gt; gt;gt; 32 = UFA
gt; gt; gt;gt; 33 = UFA
gt; gt; gt;gt; 34 = UFA
gt; gt; gt;gt; 35 = UFA
gt; gt; gt;gt; 36 = UFA
gt; gt; gt;gt; 37 = UFA
gt; gt; gt;gt; 38 = UFA
gt; gt; gt;gt; 39 = UFA
gt; gt; gt;gt; 40 = UFA
gt; gt; gt;gt; 41 = UFA
gt; gt; gt;gt; 42 = UFA
gt; gt; gt;gt; 43 = UFA
gt; gt; gt;gt; 44 = UFA
gt; gt; gt;gt; 45 = UFA
gt; gt; gt;gt;
gt; gt; gt;gt; Thanks for the help Biff
gt; gt; gt;gt;
gt; gt; gt;gt; quot;Biffquot; wrote:
gt; gt; gt;gt;
gt; gt; gt;gt; gt; Hi!
gt; gt; gt;gt; gt;
gt; gt; gt;gt; gt; What's the relation of column A to column B? Are you only
interested in
gt; gt; gt;gt; gt; column A values of 1? If so:
gt; gt; gt;gt; gt;
gt; gt; gt;gt; gt;
=IF(A1=1,IF(ISNUMBER(B1),LOOKUP(B1,{0;17;25;29},{quot; quot;;quot;RFA1quot;;quot;RFA2quot;;quot;UFAquot;}),quot;quot;
),quot;quot;)
gt; gt; gt;gt; gt;
gt; gt; gt;gt; gt; Biff
gt; gt; gt;gt; gt;
gt; gt; gt;gt; gt; quot;Killerquot; gt; wrote in message
gt; gt; gt;gt; gt; ...
gt; gt; gt;gt; gt; gt; Hello
gt; gt; gt;gt; gt; gt;
gt; gt; gt;gt; gt; gt; Having a little problem getting this code to work I tired many
things
gt; gt; gt;gt; gt; gt; including IF commands amp; VLOOKUP and I either get a N/A or False
gt; gt; gt;gt; gt; gt; response
gt; gt; gt;gt; gt; gt; from
gt; gt; gt;gt; gt; gt; the codes I have tried. It consists of three columns listed
below.
gt; gt; gt;gt; gt; gt;
gt; gt; gt;gt; gt; gt; A / B / C
gt; gt; gt;gt; gt; gt;
gt; gt; gt;gt; gt; gt; Column A: had random numbers from 1 to 8
gt; gt; gt;gt; gt; gt; Example:
gt; gt; gt;gt; gt; gt; 1. 4
gt; gt; gt;gt; gt; gt; 2. 5
gt; gt; gt;gt; gt; gt; 3. 1
gt; gt; gt;gt; gt; gt; 4. 8
gt; gt; gt;gt; gt; gt;
gt; gt; gt;gt; gt; gt; Column B: Could have numbers from 17 to 45 being listed
gt; gt; gt;gt; gt; gt; Example:
gt; gt; gt;gt; gt; gt; 1. 17
gt; gt; gt;gt; gt; gt; 2. 42
gt; gt; gt;gt; gt; gt; 3. 25
gt; gt; gt;gt; gt; gt; 4. 32
gt; gt; gt;gt; gt; gt;
gt; gt; gt;gt; gt; gt; Column C is where I want the result to show either RFA1, RFA2 or
UFA
gt; gt; gt;gt; gt; gt; This depends on the two factors:
gt; gt; gt;gt; gt; gt; Example:
gt; gt; gt;gt; gt; gt;
gt; gt; gt;gt; gt; gt; If column A =1 (A3) then lookup column B (B3) =25 Then LOOKUP
this
gt; gt; gt;gt; gt; gt; chart
gt; gt; gt;gt; gt; gt; listed below: 25 = RFA2
gt; gt; gt;gt; gt; gt;
gt; gt; gt;gt; gt; gt; 17 = RFA1
gt; gt; gt;gt; gt; gt; 18 = RFA1
gt; gt; gt;gt; gt; gt; 19 = RFA1
gt; gt; gt;gt; gt; gt; 20 = RFA1
gt; gt; gt;gt; gt; gt; 21 = RFA1
gt; gt; gt;gt; gt; gt; 22 = RFA1
gt; gt; gt;gt; gt; gt; 23 = RFA1
gt; gt; gt;gt; gt; gt; 24 = RFA1
gt; gt; gt;gt; gt; gt; 25 = RFA2
gt; gt; gt;gt; gt; gt; 26 = RFA2
gt; gt; gt;gt; gt; gt; 27 = RFA2
gt; gt; gt;gt; gt; gt; 28 = RFA2
gt; gt; gt;gt; gt; gt; 29 = UFA
gt; gt; gt;gt; gt; gt; 30 = UFA
gt; gt; gt;gt; gt; gt; 31 = UFA
gt; gt; gt;gt; gt; gt; 32 = UFA
gt; gt; gt;gt; gt; gt; 33 = UFA
gt; gt; gt;gt; gt; gt; 34 = UFA
gt; gt; gt;gt; gt; gt; 35 = UFA
gt; gt; gt;gt; gt; gt; 36 = UFA
gt; gt; gt;gt; gt; gt; 37 = UFA
gt; gt; gt;gt; gt; gt; 38 = UFA
gt; gt; gt;gt; gt; gt; 39 = UFA
gt; gt; gt;gt; gt; gt; 40 = UFA
gt; gt; gt;gt; gt; gt; 41 = UFA
gt; gt; gt;gt; gt; gt; 42 = UFA
gt; gt; gt;gt; gt; gt; 43 = UFA
gt; gt; gt;gt; gt; gt; 44 = UFA
gt; gt; gt;gt; gt; gt; 45 = UFA
gt; gt; gt;gt; gt; gt;
gt; gt; gt;gt; gt; gt;
gt; gt; gt;gt; gt; gt; The chart above will be listed on a separate page if needed, but
I'm
gt; gt; gt;gt; gt; gt; thinking a chart may not be required. Any help would be
appreciated
gt; gt; gt;gt; gt; gt;
gt; gt; gt;gt; gt;
gt; gt; gt;gt; gt;
gt; gt; gt;gt; gt;
gt; gt;
gt; gt;
gt; gt;And correcting this would require?

quot;Ragdyerquot; wrote:

gt; I'll bet your quot;numbersquot; are not *true* XL numbers, but perhaps numeric text.
gt; --
gt; Regards,
gt;
gt; RD
gt;
gt; ---------------------------------------------------------------------------
gt; Please keep all correspondence within the NewsGroup, so all may benefit !
gt; ---------------------------------------------------------------------------
gt; quot;Killerquot; gt; wrote in message
gt; ...
gt; gt; The code you posted first works fine Biff Thanks... Just for some strange
gt; gt; season it's not showing anything if I add the code to a data sheet I have
gt; gt; created but works fine if I create a new sheet... Weird I must say.
gt; gt;
gt; gt;
gt; gt; quot;Biffquot; wrote:
gt; gt;
gt; gt; gt; Ok, I'm not understanding this!
gt; gt; gt;
gt; gt; gt; gt;gt; Actually both columns are required.
gt; gt; gt;
gt; gt; gt; How? What is the relation?
gt; gt; gt;
gt; gt; gt; Based on you posted sample:
gt; gt; gt;
gt; gt; gt; A...........B..........C
gt; gt; gt; 4...........17
gt; gt; gt; 5...........42
gt; gt; gt; 1...........25
gt; gt; gt; 8...........32
gt; gt; gt;
gt; gt; gt; What results would you expect in column C?
gt; gt; gt;
gt; gt; gt; Biff
gt; gt; gt;
gt; gt; gt; quot;Killerquot; gt; wrote in message
gt; gt; gt; ...
gt; gt; gt; gt; Ok I tried that code and it seems to work great but there's one little
gt; gt; gt; gt; problem it only works a blank worksheet but not the sheet that I have
gt; all
gt; gt; gt; gt; my
gt; gt; gt; gt; data. The data sheet it's not listing anything leaving it blank. What
gt; gt; gt; gt; could
gt; gt; gt; gt; that be?
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Killerquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt;gt; Actually both columns are required.
gt; gt; gt; gt;gt;
gt; gt; gt; gt;gt; Because if column A1 =1 then it should look into column B1 and get
gt; the
gt; gt; gt; gt;gt; information from there then look into the chart below. To give the
gt; value
gt; gt; gt; gt;gt; in
gt; gt; gt; gt;gt; column C1
gt; gt; gt; gt;gt;
gt; gt; gt; gt;gt;
gt; gt; gt; gt;gt; 17 = RFA1
gt; gt; gt; gt;gt; 18 = RFA1
gt; gt; gt; gt;gt; 19 = RFA1
gt; gt; gt; gt;gt; 20 = RFA1
gt; gt; gt; gt;gt; 21 = RFA1
gt; gt; gt; gt;gt; 22 = RFA1
gt; gt; gt; gt;gt; 23 = RFA1
gt; gt; gt; gt;gt; 24 = RFA1
gt; gt; gt; gt;gt; 25 = RFA2
gt; gt; gt; gt;gt; 26 = RFA2
gt; gt; gt; gt;gt; 27 = RFA2
gt; gt; gt; gt;gt; 28 = RFA2
gt; gt; gt; gt;gt; 29 = UFA
gt; gt; gt; gt;gt; 30 = UFA
gt; gt; gt; gt;gt; 31 = UFA
gt; gt; gt; gt;gt; 32 = UFA
gt; gt; gt; gt;gt; 33 = UFA
gt; gt; gt; gt;gt; 34 = UFA
gt; gt; gt; gt;gt; 35 = UFA
gt; gt; gt; gt;gt; 36 = UFA
gt; gt; gt; gt;gt; 37 = UFA
gt; gt; gt; gt;gt; 38 = UFA
gt; gt; gt; gt;gt; 39 = UFA
gt; gt; gt; gt;gt; 40 = UFA
gt; gt; gt; gt;gt; 41 = UFA
gt; gt; gt; gt;gt; 42 = UFA
gt; gt; gt; gt;gt; 43 = UFA
gt; gt; gt; gt;gt; 44 = UFA
gt; gt; gt; gt;gt; 45 = UFA
gt; gt; gt; gt;gt;
gt; gt; gt; gt;gt; Thanks for the help Biff
gt; gt; gt; gt;gt;
gt; gt; gt; gt;gt; quot;Biffquot; wrote:
gt; gt; gt; gt;gt;
gt; gt; gt; gt;gt; gt; Hi!
gt; gt; gt; gt;gt; gt;
gt; gt; gt; gt;gt; gt; What's the relation of column A to column B? Are you only
gt; interested in
gt; gt; gt; gt;gt; gt; column A values of 1? If so:
gt; gt; gt; gt;gt; gt;
gt; gt; gt; gt;gt; gt;
gt; =IF(A1=1,IF(ISNUMBER(B1),LOOKUP(B1,{0;17;25;29},{quot; quot;;quot;RFA1quot;;quot;RFA2quot;;quot;UFAquot;}),quot;quot;
gt; ),quot;quot;)
gt; gt; gt; gt;gt; gt;
gt; gt; gt; gt;gt; gt; Biff
gt; gt; gt; gt;gt; gt;
gt; gt; gt; gt;gt; gt; quot;Killerquot; gt; wrote in message
gt; gt; gt; gt;gt; gt; ...
gt; gt; gt; gt;gt; gt; gt; Hello
gt; gt; gt; gt;gt; gt; gt;
gt; gt; gt; gt;gt; gt; gt; Having a little problem getting this code to work I tired many
gt; things
gt; gt; gt; gt;gt; gt; gt; including IF commands amp; VLOOKUP and I either get a N/A or False
gt; gt; gt; gt;gt; gt; gt; response
gt; gt; gt; gt;gt; gt; gt; from
gt; gt; gt; gt;gt; gt; gt; the codes I have tried. It consists of three columns listed
gt; below.
gt; gt; gt; gt;gt; gt; gt;
gt; gt; gt; gt;gt; gt; gt; A / B / C
gt; gt; gt; gt;gt; gt; gt;
gt; gt; gt; gt;gt; gt; gt; Column A: had random numbers from 1 to 8
gt; gt; gt; gt;gt; gt; gt; Example:
gt; gt; gt; gt;gt; gt; gt; 1. 4
gt; gt; gt; gt;gt; gt; gt; 2. 5
gt; gt; gt; gt;gt; gt; gt; 3. 1
gt; gt; gt; gt;gt; gt; gt; 4. 8
gt; gt; gt; gt;gt; gt; gt;
gt; gt; gt; gt;gt; gt; gt; Column B: Could have numbers from 17 to 45 being listed
gt; gt; gt; gt;gt; gt; gt; Example:
gt; gt; gt; gt;gt; gt; gt; 1. 17
gt; gt; gt; gt;gt; gt; gt; 2. 42
gt; gt; gt; gt;gt; gt; gt; 3. 25
gt; gt; gt; gt;gt; gt; gt; 4. 32
gt; gt; gt; gt;gt; gt; gt;
gt; gt; gt; gt;gt; gt; gt; Column C is where I want the result to show either RFA1, RFA2 or
gt; UFA
gt; gt; gt; gt;gt; gt; gt; This depends on the two factors:
gt; gt; gt; gt;gt; gt; gt; Example:
gt; gt; gt; gt;gt; gt; gt;
gt; gt; gt; gt;gt; gt; gt; If column A =1 (A3) then lookup column B (B3) =25 Then LOOKUP
gt; this
gt; gt; gt; gt;gt; gt; gt; chart
gt; gt; gt; gt;gt; gt; gt; listed below: 25 = RFA2
gt; gt; gt; gt;gt; gt; gt;
gt; gt; gt; gt;gt; gt; gt; 17 = RFA1
gt; gt; gt; gt;gt; gt; gt; 18 = RFA1
gt; gt; gt; gt;gt; gt; gt; 19 = RFA1
gt; gt; gt; gt;gt; gt; gt; 20 = RFA1
gt; gt; gt; gt;gt; gt; gt; 21 = RFA1
gt; gt; gt; gt;gt; gt; gt; 22 = RFA1
gt; gt; gt; gt;gt; gt; gt; 23 = RFA1
gt; gt; gt; gt;gt; gt; gt; 24 = RFA1
gt; gt; gt; gt;gt; gt; gt; 25 = RFA2
gt; gt; gt; gt;gt; gt; gt; 26 = RFA2
gt; gt; gt; gt;gt; gt; gt; 27 = RFA2
gt; gt; gt; gt;gt; gt; gt; 28 = RFA2
gt; gt; gt; gt;gt; gt; gt; 29 = UFA
gt; gt; gt; gt;gt; gt; gt; 30 = UFA
gt; gt; gt; gt;gt; gt; gt; 31 = UFA
gt; gt; gt; gt;gt; gt; gt; 32 = UFA
gt; gt; gt; gt;gt; gt; gt; 33 = UFA
gt; gt; gt; gt;gt; gt; gt; 34 = UFA
gt; gt; gt; gt;gt; gt; gt; 35 = UFA
gt; gt; gt; gt;gt; gt; gt; 36 = UFA
gt; gt; gt; gt;gt; gt; gt; 37 = UFA
gt; gt; gt; gt;gt; gt; gt; 38 = UFA
gt; gt; gt; gt;gt; gt; gt; 39 = UFA
gt; gt; gt; gt;gt; gt; gt; 40 = UFA
gt; gt; gt; gt;gt; gt; gt; 41 = UFA
gt; gt; gt; gt;gt; gt; gt; 42 = UFA
gt; gt; gt; gt;gt; gt; gt; 43 = UFA
gt; gt; gt; gt;gt; gt; gt; 44 = UFA
gt; gt; gt; gt;gt; gt; gt; 45 = UFA
gt; gt; gt; gt;gt; gt; gt;
gt; gt; gt; gt;gt; gt; gt;
gt; gt; gt; gt;gt; gt; gt; The chart above will be listed on a separate page if needed, but
gt; I'm
gt; gt; gt; gt;gt; gt; gt; thinking a chart may not be required. Any help would be
gt; appreciated
gt; gt; gt; gt;gt; gt; gt;
gt; gt; gt; gt;gt; gt;
gt; gt; gt; gt;gt; gt;
gt; gt; gt; gt;gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt;
gt;

Format all to General.

Copy an empty cell then select all quot;numbersquot; cells and Paste Specialgt;Addgt;OKgt;Esc.

This will coerce the text nums to real nums.Gord Dibben MS Excel MVP

On Sun, 23 Apr 2006 14:23:02 -0700, Killer gt;
wrote:

gt;And correcting this would require?
gt;
gt;quot;Ragdyerquot; wrote:
gt;
gt;gt; I'll bet your quot;numbersquot; are not *true* XL numbers, but perhaps numeric text.
gt;gt; --
gt;gt; Regards,
gt;gt;
gt;gt; RD
gt;gt;
gt;gt; ---------------------------------------------------------------------------
gt;gt; Please keep all correspondence within the NewsGroup, so all may benefit !
gt;gt; ---------------------------------------------------------------------------
gt;gt; quot;Killerquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; The code you posted first works fine Biff Thanks... Just for some strange
gt;gt; gt; season it's not showing anything if I add the code to a data sheet I have
gt;gt; gt; created but works fine if I create a new sheet... Weird I must say.
gt;gt; gt;
gt;gt; gt;
gt;gt; gt; quot;Biffquot; wrote:
gt;gt; gt;
gt;gt; gt; gt; Ok, I'm not understanding this!
gt;gt; gt; gt;
gt;gt; gt; gt; gt;gt; Actually both columns are required.
gt;gt; gt; gt;
gt;gt; gt; gt; How? What is the relation?
gt;gt; gt; gt;
gt;gt; gt; gt; Based on you posted sample:
gt;gt; gt; gt;
gt;gt; gt; gt; A...........B..........C
gt;gt; gt; gt; 4...........17
gt;gt; gt; gt; 5...........42
gt;gt; gt; gt; 1...........25
gt;gt; gt; gt; 8...........32
gt;gt; gt; gt;
gt;gt; gt; gt; What results would you expect in column C?
gt;gt; gt; gt;
gt;gt; gt; gt; Biff
gt;gt; gt; gt;
gt;gt; gt; gt; quot;Killerquot; gt; wrote in message
gt;gt; gt; gt; ...
gt;gt; gt; gt; gt; Ok I tried that code and it seems to work great but there's one little
gt;gt; gt; gt; gt; problem it only works a blank worksheet but not the sheet that I have
gt;gt; all
gt;gt; gt; gt; gt; my
gt;gt; gt; gt; gt; data. The data sheet it's not listing anything leaving it blank. What
gt;gt; gt; gt; gt; could
gt;gt; gt; gt; gt; that be?
gt;gt; gt; gt; gt;
gt;gt; gt; gt; gt;
gt;gt; gt; gt; gt; quot;Killerquot; wrote:
gt;gt; gt; gt; gt;
gt;gt; gt; gt; gt;gt; Actually both columns are required.
gt;gt; gt; gt; gt;gt;
gt;gt; gt; gt; gt;gt; Because if column A1 =1 then it should look into column B1 and get
gt;gt; the
gt;gt; gt; gt; gt;gt; information from there then look into the chart below. To give the
gt;gt; value
gt;gt; gt; gt; gt;gt; in
gt;gt; gt; gt; gt;gt; column C1
gt;gt; gt; gt; gt;gt;
gt;gt; gt; gt; gt;gt;
gt;gt; gt; gt; gt;gt; 17 = RFA1
gt;gt; gt; gt; gt;gt; 18 = RFA1
gt;gt; gt; gt; gt;gt; 19 = RFA1
gt;gt; gt; gt; gt;gt; 20 = RFA1
gt;gt; gt; gt; gt;gt; 21 = RFA1
gt;gt; gt; gt; gt;gt; 22 = RFA1
gt;gt; gt; gt; gt;gt; 23 = RFA1
gt;gt; gt; gt; gt;gt; 24 = RFA1
gt;gt; gt; gt; gt;gt; 25 = RFA2
gt;gt; gt; gt; gt;gt; 26 = RFA2
gt;gt; gt; gt; gt;gt; 27 = RFA2
gt;gt; gt; gt; gt;gt; 28 = RFA2
gt;gt; gt; gt; gt;gt; 29 = UFA
gt;gt; gt; gt; gt;gt; 30 = UFA
gt;gt; gt; gt; gt;gt; 31 = UFA
gt;gt; gt; gt; gt;gt; 32 = UFA
gt;gt; gt; gt; gt;gt; 33 = UFA
gt;gt; gt; gt; gt;gt; 34 = UFA
gt;gt; gt; gt; gt;gt; 35 = UFA
gt;gt; gt; gt; gt;gt; 36 = UFA
gt;gt; gt; gt; gt;gt; 37 = UFA
gt;gt; gt; gt; gt;gt; 38 = UFA
gt;gt; gt; gt; gt;gt; 39 = UFA
gt;gt; gt; gt; gt;gt; 40 = UFA
gt;gt; gt; gt; gt;gt; 41 = UFA
gt;gt; gt; gt; gt;gt; 42 = UFA
gt;gt; gt; gt; gt;gt; 43 = UFA
gt;gt; gt; gt; gt;gt; 44 = UFA
gt;gt; gt; gt; gt;gt; 45 = UFA
gt;gt; gt; gt; gt;gt;
gt;gt; gt; gt; gt;gt; Thanks for the help Biff
gt;gt; gt; gt; gt;gt;
gt;gt; gt; gt; gt;gt; quot;Biffquot; wrote:
gt;gt; gt; gt; gt;gt;
gt;gt; gt; gt; gt;gt; gt; Hi!
gt;gt; gt; gt; gt;gt; gt;
gt;gt; gt; gt; gt;gt; gt; What's the relation of column A to column B? Are you only
gt;gt; interested in
gt;gt; gt; gt; gt;gt; gt; column A values of 1? If so:
gt;gt; gt; gt; gt;gt; gt;
gt;gt; gt; gt; gt;gt; gt;
gt;gt; =IF(A1=1,IF(ISNUMBER(B1),LOOKUP(B1,{0;17;25;29},{quot; quot;;quot;RFA1quot;;quot;RFA2quot;;quot;UFAquot;}),quot;quot;
gt;gt; ),quot;quot;)
gt;gt; gt; gt; gt;gt; gt;
gt;gt; gt; gt; gt;gt; gt; Biff
gt;gt; gt; gt; gt;gt; gt;
gt;gt; gt; gt; gt;gt; gt; quot;Killerquot; gt; wrote in message
gt;gt; gt; gt; gt;gt; gt; ...
gt;gt; gt; gt; gt;gt; gt; gt; Hello
gt;gt; gt; gt; gt;gt; gt; gt;
gt;gt; gt; gt; gt;gt; gt; gt; Having a little problem getting this code to work I tired many
gt;gt; things
gt;gt; gt; gt; gt;gt; gt; gt; including IF commands amp; VLOOKUP and I either get a N/A or False
gt;gt; gt; gt; gt;gt; gt; gt; response
gt;gt; gt; gt; gt;gt; gt; gt; from
gt;gt; gt; gt; gt;gt; gt; gt; the codes I have tried. It consists of three columns listed
gt;gt; below.
gt;gt; gt; gt; gt;gt; gt; gt;
gt;gt; gt; gt; gt;gt; gt; gt; A / B / C
gt;gt; gt; gt; gt;gt; gt; gt;
gt;gt; gt; gt; gt;gt; gt; gt; Column A: had random numbers from 1 to 8
gt;gt; gt; gt; gt;gt; gt; gt; Example:
gt;gt; gt; gt; gt;gt; gt; gt; 1. 4
gt;gt; gt; gt; gt;gt; gt; gt; 2. 5
gt;gt; gt; gt; gt;gt; gt; gt; 3. 1
gt;gt; gt; gt; gt;gt; gt; gt; 4. 8
gt;gt; gt; gt; gt;gt; gt; gt;
gt;gt; gt; gt; gt;gt; gt; gt; Column B: Could have numbers from 17 to 45 being listed
gt;gt; gt; gt; gt;gt; gt; gt; Example:
gt;gt; gt; gt; gt;gt; gt; gt; 1. 17
gt;gt; gt; gt; gt;gt; gt; gt; 2. 42
gt;gt; gt; gt; gt;gt; gt; gt; 3. 25
gt;gt; gt; gt; gt;gt; gt; gt; 4. 32
gt;gt; gt; gt; gt;gt; gt; gt;
gt;gt; gt; gt; gt;gt; gt; gt; Column C is where I want the result to show either RFA1, RFA2 or
gt;gt; UFA
gt;gt; gt; gt; gt;gt; gt; gt; This depends on the two factors:
gt;gt; gt; gt; gt;gt; gt; gt; Example:
gt;gt; gt; gt; gt;gt; gt; gt;
gt;gt; gt; gt; gt;gt; gt; gt; If column A =1 (A3) then lookup column B (B3) =25 Then LOOKUP
gt;gt; this
gt;gt; gt; gt; gt;gt; gt; gt; chart
gt;gt; gt; gt; gt;gt; gt; gt; listed below: 25 = RFA2
gt;gt; gt; gt; gt;gt; gt; gt;
gt;gt; gt; gt; gt;gt; gt; gt; 17 = RFA1
gt;gt; gt; gt; gt;gt; gt; gt; 18 = RFA1
gt;gt; gt; gt; gt;gt; gt; gt; 19 = RFA1
gt;gt; gt; gt; gt;gt; gt; gt; 20 = RFA1
gt;gt; gt; gt; gt;gt; gt; gt; 21 = RFA1
gt;gt; gt; gt; gt;gt; gt; gt; 22 = RFA1
gt;gt; gt; gt; gt;gt; gt; gt; 23 = RFA1
gt;gt; gt; gt; gt;gt; gt; gt; 24 = RFA1
gt;gt; gt; gt; gt;gt; gt; gt; 25 = RFA2
gt;gt; gt; gt; gt;gt; gt; gt; 26 = RFA2
gt;gt; gt; gt; gt;gt; gt; gt; 27 = RFA2
gt;gt; gt; gt; gt;gt; gt; gt; 28 = RFA2
gt;gt; gt; gt; gt;gt; gt; gt; 29 = UFA
gt;gt; gt; gt; gt;gt; gt; gt; 30 = UFA
gt;gt; gt; gt; gt;gt; gt; gt; 31 = UFA
gt;gt; gt; gt; gt;gt; gt; gt; 32 = UFA
gt;gt; gt; gt; gt;gt; gt; gt; 33 = UFA
gt;gt; gt; gt; gt;gt; gt; gt; 34 = UFA
gt;gt; gt; gt; gt;gt; gt; gt; 35 = UFA
gt;gt; gt; gt; gt;gt; gt; gt; 36 = UFA
gt;gt; gt; gt; gt;gt; gt; gt; 37 = UFA
gt;gt; gt; gt; gt;gt; gt; gt; 38 = UFA
gt;gt; gt; gt; gt;gt; gt; gt; 39 = UFA
gt;gt; gt; gt; gt;gt; gt; gt; 40 = UFA
gt;gt; gt; gt; gt;gt; gt; gt; 41 = UFA
gt;gt; gt; gt; gt;gt; gt; gt; 42 = UFA
gt;gt; gt; gt; gt;gt; gt; gt; 43 = UFA
gt;gt; gt; gt; gt;gt; gt; gt; 44 = UFA
gt;gt; gt; gt; gt;gt; gt; gt; 45 = UFA
gt;gt; gt; gt; gt;gt; gt; gt;
gt;gt; gt; gt; gt;gt; gt; gt;
gt;gt; gt; gt; gt;gt; gt; gt; The chart above will be listed on a separate page if needed, but
gt;gt; I'm
gt;gt; gt; gt; gt;gt; gt; gt; thinking a chart may not be required. Any help would be
gt;gt; appreciated
gt;gt; gt; gt; gt;gt; gt; gt;
gt;gt; gt; gt; gt;gt; gt;
gt;gt; gt; gt; gt;gt; gt;
gt;gt; gt; gt; gt;gt; gt;
gt;gt; gt; gt;
gt;gt; gt; gt;
gt;gt; gt; gt;
gt;gt;
gt;gt;Actually, the second half of Gord's suggestion will take care of the
formatting, where you don't have to format to General in a separate, extra
step.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
quot;Gord Dibbenquot; lt;gorddibbATshawDOTcagt; wrote in message
...
gt; Format all to General.
gt;
gt; Copy an empty cell then select all quot;numbersquot; cells and Paste
Specialgt;Addgt;OKgt;Esc.
gt;
gt; This will coerce the text nums to real nums.
gt;
gt;
gt; Gord Dibben MS Excel MVP
gt;
gt; On Sun, 23 Apr 2006 14:23:02 -0700, Killer
gt;
gt; wrote:
gt;
gt; gt;And correcting this would require?
gt; gt;
gt; gt;quot;Ragdyerquot; wrote:
gt; gt;
gt; gt;gt; I'll bet your quot;numbersquot; are not *true* XL numbers, but perhaps numeric
text.
gt; gt;gt; --
gt; gt;gt; Regards,
gt; gt;gt;
gt; gt;gt; RD
gt; gt;gt;
gt;
gt;gt; -------------------------------------------------------------------------
--
gt; gt;gt; Please keep all correspondence within the NewsGroup, so all may benefit
!
gt;
gt;gt; -------------------------------------------------------------------------
--
gt; gt;gt; quot;Killerquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; The code you posted first works fine Biff Thanks... Just for some
strange
gt; gt;gt; gt; season it's not showing anything if I add the code to a data sheet I
have
gt; gt;gt; gt; created but works fine if I create a new sheet... Weird I must say.
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt; gt; quot;Biffquot; wrote:
gt; gt;gt; gt;
gt; gt;gt; gt; gt; Ok, I'm not understanding this!
gt; gt;gt; gt; gt;
gt; gt;gt; gt; gt; gt;gt; Actually both columns are required.
gt; gt;gt; gt; gt;
gt; gt;gt; gt; gt; How? What is the relation?
gt; gt;gt; gt; gt;
gt; gt;gt; gt; gt; Based on you posted sample:
gt; gt;gt; gt; gt;
gt; gt;gt; gt; gt; A...........B..........C
gt; gt;gt; gt; gt; 4...........17
gt; gt;gt; gt; gt; 5...........42
gt; gt;gt; gt; gt; 1...........25
gt; gt;gt; gt; gt; 8...........32
gt; gt;gt; gt; gt;
gt; gt;gt; gt; gt; What results would you expect in column C?
gt; gt;gt; gt; gt;
gt; gt;gt; gt; gt; Biff
gt; gt;gt; gt; gt;
gt; gt;gt; gt; gt; quot;Killerquot; gt; wrote in message
gt; gt;gt; gt; gt; ...
gt; gt;gt; gt; gt; gt; Ok I tried that code and it seems to work great but there's one
little
gt; gt;gt; gt; gt; gt; problem it only works a blank worksheet but not the sheet that I
have
gt; gt;gt; all
gt; gt;gt; gt; gt; gt; my
gt; gt;gt; gt; gt; gt; data. The data sheet it's not listing anything leaving it blank.
What
gt; gt;gt; gt; gt; gt; could
gt; gt;gt; gt; gt; gt; that be?
gt; gt;gt; gt; gt; gt;
gt; gt;gt; gt; gt; gt;
gt; gt;gt; gt; gt; gt; quot;Killerquot; wrote:
gt; gt;gt; gt; gt; gt;
gt; gt;gt; gt; gt; gt;gt; Actually both columns are required.
gt; gt;gt; gt; gt; gt;gt;
gt; gt;gt; gt; gt; gt;gt; Because if column A1 =1 then it should look into column B1 and
get
gt; gt;gt; the
gt; gt;gt; gt; gt; gt;gt; information from there then look into the chart below. To give
the
gt; gt;gt; value
gt; gt;gt; gt; gt; gt;gt; in
gt; gt;gt; gt; gt; gt;gt; column C1
gt; gt;gt; gt; gt; gt;gt;
gt; gt;gt; gt; gt; gt;gt;
gt; gt;gt; gt; gt; gt;gt; 17 = RFA1
gt; gt;gt; gt; gt; gt;gt; 18 = RFA1
gt; gt;gt; gt; gt; gt;gt; 19 = RFA1
gt; gt;gt; gt; gt; gt;gt; 20 = RFA1
gt; gt;gt; gt; gt; gt;gt; 21 = RFA1
gt; gt;gt; gt; gt; gt;gt; 22 = RFA1
gt; gt;gt; gt; gt; gt;gt; 23 = RFA1
gt; gt;gt; gt; gt; gt;gt; 24 = RFA1
gt; gt;gt; gt; gt; gt;gt; 25 = RFA2
gt; gt;gt; gt; gt; gt;gt; 26 = RFA2
gt; gt;gt; gt; gt; gt;gt; 27 = RFA2
gt; gt;gt; gt; gt; gt;gt; 28 = RFA2
gt; gt;gt; gt; gt; gt;gt; 29 = UFA
gt; gt;gt; gt; gt; gt;gt; 30 = UFA
gt; gt;gt; gt; gt; gt;gt; 31 = UFA
gt; gt;gt; gt; gt; gt;gt; 32 = UFA
gt; gt;gt; gt; gt; gt;gt; 33 = UFA
gt; gt;gt; gt; gt; gt;gt; 34 = UFA
gt; gt;gt; gt; gt; gt;gt; 35 = UFA
gt; gt;gt; gt; gt; gt;gt; 36 = UFA
gt; gt;gt; gt; gt; gt;gt; 37 = UFA
gt; gt;gt; gt; gt; gt;gt; 38 = UFA
gt; gt;gt; gt; gt; gt;gt; 39 = UFA
gt; gt;gt; gt; gt; gt;gt; 40 = UFA
gt; gt;gt; gt; gt; gt;gt; 41 = UFA
gt; gt;gt; gt; gt; gt;gt; 42 = UFA
gt; gt;gt; gt; gt; gt;gt; 43 = UFA
gt; gt;gt; gt; gt; gt;gt; 44 = UFA
gt; gt;gt; gt; gt; gt;gt; 45 = UFA
gt; gt;gt; gt; gt; gt;gt;
gt; gt;gt; gt; gt; gt;gt; Thanks for the help Biff
gt; gt;gt; gt; gt; gt;gt;
gt; gt;gt; gt; gt; gt;gt; quot;Biffquot; wrote:
gt; gt;gt; gt; gt; gt;gt;
gt; gt;gt; gt; gt; gt;gt; gt; Hi!
gt; gt;gt; gt; gt; gt;gt; gt;
gt; gt;gt; gt; gt; gt;gt; gt; What's the relation of column A to column B? Are you only
gt; gt;gt; interested in
gt; gt;gt; gt; gt; gt;gt; gt; column A values of 1? If so:
gt; gt;gt; gt; gt; gt;gt; gt;
gt; gt;gt; gt; gt; gt;gt; gt;
gt; gt;gt;
=IF(A1=1,IF(ISNUMBER(B1),LOOKUP(B1,{0;17;25;29},{quot; quot;;quot;RFA1quot;;quot;RFA2quot;;quot;UFAquot;}),quot;quot;
gt; gt;gt; ),quot;quot;)
gt; gt;gt; gt; gt; gt;gt; gt;
gt; gt;gt; gt; gt; gt;gt; gt; Biff
gt; gt;gt; gt; gt; gt;gt; gt;
gt; gt;gt; gt; gt; gt;gt; gt; quot;Killerquot; gt; wrote in message
gt; gt;gt; gt; gt; gt;gt; gt; ...
gt; gt;gt; gt; gt; gt;gt; gt; gt; Hello
gt; gt;gt; gt; gt; gt;gt; gt; gt;
gt; gt;gt; gt; gt; gt;gt; gt; gt; Having a little problem getting this code to work I tired
many
gt; gt;gt; things
gt; gt;gt; gt; gt; gt;gt; gt; gt; including IF commands amp; VLOOKUP and I either get a N/A or
False
gt; gt;gt; gt; gt; gt;gt; gt; gt; response
gt; gt;gt; gt; gt; gt;gt; gt; gt; from
gt; gt;gt; gt; gt; gt;gt; gt; gt; the codes I have tried. It consists of three columns listed
gt; gt;gt; below.
gt; gt;gt; gt; gt; gt;gt; gt; gt;
gt; gt;gt; gt; gt; gt;gt; gt; gt; A / B / C
gt; gt;gt; gt; gt; gt;gt; gt; gt;
gt; gt;gt; gt; gt; gt;gt; gt; gt; Column A: had random numbers from 1 to 8
gt; gt;gt; gt; gt; gt;gt; gt; gt; Example:
gt; gt;gt; gt; gt; gt;gt; gt; gt; 1. 4
gt; gt;gt; gt; gt; gt;gt; gt; gt; 2. 5
gt; gt;gt; gt; gt; gt;gt; gt; gt; 3. 1
gt; gt;gt; gt; gt; gt;gt; gt; gt; 4. 8
gt; gt;gt; gt; gt; gt;gt; gt; gt;
gt; gt;gt; gt; gt; gt;gt; gt; gt; Column B: Could have numbers from 17 to 45 being listed
gt; gt;gt; gt; gt; gt;gt; gt; gt; Example:
gt; gt;gt; gt; gt; gt;gt; gt; gt; 1. 17
gt; gt;gt; gt; gt; gt;gt; gt; gt; 2. 42
gt; gt;gt; gt; gt; gt;gt; gt; gt; 3. 25
gt; gt;gt; gt; gt; gt;gt; gt; gt; 4. 32
gt; gt;gt; gt; gt; gt;gt; gt; gt;
gt; gt;gt; gt; gt; gt;gt; gt; gt; Column C is where I want the result to show either RFA1,
RFA2 or
gt; gt;gt; UFA
gt; gt;gt; gt; gt; gt;gt; gt; gt; This depends on the two factors:
gt; gt;gt; gt; gt; gt;gt; gt; gt; Example:
gt; gt;gt; gt; gt; gt;gt; gt; gt;
gt; gt;gt; gt; gt; gt;gt; gt; gt; If column A =1 (A3) then lookup column B (B3) =25 Then
LOOKUP
gt; gt;gt; this
gt; gt;gt; gt; gt; gt;gt; gt; gt; chart
gt; gt;gt; gt; gt; gt;gt; gt; gt; listed below: 25 = RFA2
gt; gt;gt; gt; gt; gt;gt; gt; gt;
gt; gt;gt; gt; gt; gt;gt; gt; gt; 17 = RFA1
gt; gt;gt; gt; gt; gt;gt; gt; gt; 18 = RFA1
gt; gt;gt; gt; gt; gt;gt; gt; gt; 19 = RFA1
gt; gt;gt; gt; gt; gt;gt; gt; gt; 20 = RFA1
gt; gt;gt; gt; gt; gt;gt; gt; gt; 21 = RFA1
gt; gt;gt; gt; gt; gt;gt; gt; gt; 22 = RFA1
gt; gt;gt; gt; gt; gt;gt; gt; gt; 23 = RFA1
gt; gt;gt; gt; gt; gt;gt; gt; gt; 24 = RFA1
gt; gt;gt; gt; gt; gt;gt; gt; gt; 25 = RFA2
gt; gt;gt; gt; gt; gt;gt; gt; gt; 26 = RFA2
gt; gt;gt; gt; gt; gt;gt; gt; gt; 27 = RFA2
gt; gt;gt; gt; gt; gt;gt; gt; gt; 28 = RFA2
gt; gt;gt; gt; gt; gt;gt; gt; gt; 29 = UFA
gt; gt;gt; gt; gt; gt;gt; gt; gt; 30 = UFA
gt; gt;gt; gt; gt; gt;gt; gt; gt; 31 = UFA
gt; gt;gt; gt; gt; gt;gt; gt; gt; 32 = UFA
gt; gt;gt; gt; gt; gt;gt; gt; gt; 33 = UFA
gt; gt;gt; gt; gt; gt;gt; gt; gt; 34 = UFA
gt; gt;gt; gt; gt; gt;gt; gt; gt; 35 = UFA
gt; gt;gt; gt; gt; gt;gt; gt; gt; 36 = UFA
gt; gt;gt; gt; gt; gt;gt; gt; gt; 37 = UFA
gt; gt;gt; gt; gt; gt;gt; gt; gt; 38 = UFA
gt; gt;gt; gt; gt; gt;gt; gt; gt; 39 = UFA
gt; gt;gt; gt; gt; gt;gt; gt; gt; 40 = UFA
gt; gt;gt; gt; gt; gt;gt; gt; gt; 41 = UFA
gt; gt;gt; gt; gt; gt;gt; gt; gt; 42 = UFA
gt; gt;gt; gt; gt; gt;gt; gt; gt; 43 = UFA
gt; gt;gt; gt; gt; gt;gt; gt; gt; 44 = UFA
gt; gt;gt; gt; gt; gt;gt; gt; gt; 45 = UFA
gt; gt;gt; gt; gt; gt;gt; gt; gt;
gt; gt;gt; gt; gt; gt;gt; gt; gt;
gt; gt;gt; gt; gt; gt;gt; gt; gt; The chart above will be listed on a separate page if needed,
but
gt; gt;gt; I'm
gt; gt;gt; gt; gt; gt;gt; gt; gt; thinking a chart may not be required. Any help would be
gt; gt;gt; appreciated
gt; gt;gt; gt; gt; gt;gt; gt; gt;
gt; gt;gt; gt; gt; gt;gt; gt;
gt; gt;gt; gt; gt; gt;gt; gt;
gt; gt;gt; gt; gt; gt;gt; gt;
gt; gt;gt; gt; gt;
gt; gt;gt; gt; gt;
gt; gt;gt; gt; gt;
gt; gt;gt;
gt; gt;gt;
gt;