| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
lookup returns zero or the wrong number
"=IF(RC[-2]="""","""",IF(R[-13]C[-2]=""WBM"",LOOKUP(R[11]C[-2],Densities!C[-5],Densities!C[-4]),LOOKUP(RC[-2],Densities!C[-1],Densities!C)))"
Range("H21").Select Selection.AutoFill Destination:=Range("H21:H39"), Type:=xlFillDefault Range("H21:H39").Select Range("H21").Select End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Weekday Function Returns Wrong Number | Excel Programming | |||
| cell returns wrong value | Excel Worksheet Functions | |||
| Row() function returns wrong row and more.. | Excel Worksheet Functions | |||
| Lookup returns wrong value | Excel Worksheet Functions | |||
| lookup returns row number-why? | Excel Worksheet Functions | |||
Threaded Mode
