| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP Changing reference cells in autofill
I am attempting to fill a column with this formula
=IF(ISNA(VLOOKUP(B6,Materials!B7:C50,2,FALSE)),0,V LOOKUP(B6,Materials!B7:C50,2,FALSE)) the autofill changes the B7:C50 in each reference and I'd like to keep it the same all the way down the column. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
VLOOKUP Changing reference cells in autofill
=IF(ISNA(VLOOKUP(B6,Materials!$B$7:$C$50,2,FALSE)) ,0,VLOOKUP(B6,Materials!$B$7:$C$50,2,FALSE))
Regards Trevor "Barry" wrote in message ... I am attempting to fill a column with this formula =IF(ISNA(VLOOKUP(B6,Materials!B7:C50,2,FALSE)),0,V LOOKUP(B6,Materials!B7:C50,2,FALSE)) the autofill changes the B7:C50 in each reference and I'd like to keep it the same all the way down the column. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
VLOOKUP Changing reference cells in autofill
Thanks, I appreciate your help.
"Trevor Shuttleworth" wrote: =IF(ISNA(VLOOKUP(B6,Materials!$B$7:$C$50,2,FALSE)) ,0,VLOOKUP(B6,Materials!$B$7:$C$50,2,FALSE)) Regards Trevor "Barry" wrote in message ... I am attempting to fill a column with this formula =IF(ISNA(VLOOKUP(B6,Materials!B7:C50,2,FALSE)),0,V LOOKUP(B6,Materials!B7:C50,2,FALSE)) the autofill changes the B7:C50 in each reference and I'd like to keep it the same all the way down the column. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Two Reference Cells in VLOOKUP, Probably easy but .... | Excel Discussion (Misc queries) | |||
| Compare two cells from reference cells | Excel Worksheet Functions | |||
| Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions | |||
| Autofill: Need to autofill one week block, (5) weekday only into cells. | Excel Discussion (Misc queries) | |||
| Conditional formatting on cells with a VLOOKUP formula in them | Excel Discussion (Misc queries) | |||
Linear Mode
