| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Then forumal
Shorter version:
=LOOKUP(E4,{0.05,0.14,0.23},K7:M7) "Teethless mama" wrote: =INDIRECT(LOOKUP(E4,{0.05,0.14,0.23},{"K7","L7","M 7"})) "DJ" wrote: Ok im really new to this and have been reading for hours. Heres what I'm trying to do. If E4=either.05, .14, .23 then B19=K7IF.05, L7IF.14, M7IF.23 hope that makes sense to someone thanks for any help given |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Worksheet forumal help | Setting up and Configuration of Excel | |||
| filling forumal by colums | Excel Discussion (Misc queries) | |||
| How do I chang numbers to letters on Excell forumal bar? | Excel Discussion (Misc queries) | |||
| forumal does not work | Excel Worksheet Functions | |||
Hybrid Mode
