Another Formulae Baffle

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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...
 
Hi Shane,

Use VLOOKUP()

Here's how:

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

--
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...
| --
| ShaneBrowning
 
Back
Top