Another Formulae Baffle

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Shane - 19 Jul 2007 11:22 GMT

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...

Signature

ShaneBrowning

Reply to this Message

Niek Otten - 19 Jul 2007 11:42 GMT

Hi Shane,

Use VLOOKUP()

Here's how:

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

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

|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...

Reply to this Message

Stan Brown - 20 Jul 2007 15:12 GMT

Thu, 19 Jul 2007 12:42:34 +0200 from Niek Otten <nicolaus@xs4all.nl>:

> > 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,...} )

Signature

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

Reply to this Message