| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting Formula
Hi,
I have insereted a If function in a cell, eg =IF(H5<"",VLOOKUP(H5,AJ5:AK79,2,0),""). Now I want the IF function applied to all the cells in that cloumn with the same vlookup function. The vlookup function keeps changing with the cell number, for eg it becomes =IF(H6<"",VLOOKUP(H6, AJ6:AK80,2,0),""). I need the VLOOKUP function to calculate AJ5:AK79 for all the cells. Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Inserting Formula
=IF(H5<"",VLOOKUP(H5,$AJ$5:$AK$79,2,0),"")
Use the "$" symbol to anchor your range "vcprabhu" wrote: Hi, I have insereted a If function in a cell, eg =IF(H5<"",VLOOKUP(H5,AJ5:AK79,2,0),""). Now I want the IF function applied to all the cells in that cloumn with the same vlookup function. The vlookup function keeps changing with the cell number, for eg it becomes =IF(H6<"",VLOOKUP(H6, AJ6:AK80,2,0),""). I need the VLOOKUP function to calculate AJ5:AK79 for all the cells. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting a formula into a sentance. | Excel Worksheet Functions | |||
| Inserting " in a formula | Excel Discussion (Misc queries) | |||
| inserting hard CR in a formula | Excel Worksheet Functions | |||
| inserting a formula | Excel Discussion (Misc queries) | |||
| Formula changes while inserting a row !!!! | Excel Worksheet Functions | |||
Hybrid Mode
