I am trying to create a query? that will return a value, depending on the
input value tothat cell. Tried using "if" but can only nest so many. I want
a,b,d,e,h,l,s,t,x,z (if inputted for a days work) to return (hours worked)
8,4,9,6,1,8,8,8,0.25,0.50...

tks if u can help...
--
ShaneBrowning

Hi Shane,

Use VLOOKUP()

Here's how:

http://www.contextures.com/xlFunctions02.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Shane" wrote in message ...
|I am trying to create a query? that will return a value, depending on the
| input value tothat cell. Tried using "if" but can only nest so many. I want
| a,b,d,e,h,l,s,t,x,z (if inputted for a days work) to return (hours worked)
| 8,4,9,6,1,8,8,8,0.25,0.50...
|
| tks if u can help...
| --
| ShaneBrowning

Thu, 19 Jul 2007 12:42:34 +0200 from Niek Otten :

"Shane" wrote in message
...
I am trying to create a query? that will return a value,
depending on the input value tothat cell. Tried using "if" but
can only nest so many. I want a,b,d,e,h,l,s,t,x,z (if inputted
for a days work) to return (hours worked)
8,4,9,6,1,8,8,8,0.25,0.50...

Use VLOOKUP()

Here's how:

http://www.contextures.com/xlFunctions02.html

Or plain LOOKUP, too:

=LOOKUP(A1, {"a","b",...}, {8, 4,...} )

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/