Re: Syntax for using "IF"...

What you're describing here is a simple datalist (G1 to H5), which you want polled, using the values entered in Column A.

As described, this can easily be accomplished by using the Lookup() function.

In B1, enter this formula:

=LOOKUP(A1,$G$1:$H$5)

And copy down as needed.

Now, this can become a little more complex if the values in Column A do not *exactly* match the values in Column G,
OR
The values in Column G are not *always* as you originally described here (sorted in ascending order).

So, if this is an over simplified example of your actual anticipated data, the suggested formula *might not* be a viable solution.

You might care to post back with *exact* examples of your data values for both Column G and Column A.

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"garry05" <garry05.1zondp@xxxxxxxxxxxxxxxxxxxx> wrote in message news:garry05.1zondp@xxxxxxxxxxxxxxxxxxxxxxx 

Trying to resolve a situation that I've got posted elsewhere on here;
maybe I can do it this way if someone can help me with the syntax for
using "IF".

Say that column G is numbered 1-5, and column H has values of 100, 133,
322, 440, 560.

I'll enter a number (1-5) in col A, and I want this to happen in col B,
and I'll express it in human language:  If A2=3 then B2=322...If A1=5
then B1=560.

In other words, I post a number in A, then go search G for the same
number, then post the corresponding H value into B.

I've tried the syntax every way but the right way, I guess.


Thanks,
Garry


--
garry05 

.