| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying absolute VLOOKUP
I have the following formula:
=IF(ISNA(VLOOKUP($A3,'HR Feed (HC and Co-Location)'!$A$3:$R$566,5,FALSE)),"",VLOOKUP($A3,'H R Feed (HC and Co-Location)'!$A$3:$R$566,5,FALSE)) It is copied across to 8 columns with the appropirate column reference entered twice in each one. When I copy the nine cells down, using ^C, Edit/Paste special/Formulas, it copies the resulting value from the first row, instead of the correct lookup value. Any ideas what I'm doing wrong? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying formulas, relative and absolute cell references | Excel Discussion (Misc queries) | |||
| Copying formula from one cell to another with absolute value in it | Excel Discussion (Misc queries) | |||
| Copying a work sheet cell reference as relative not absolute? | Excel Discussion (Misc queries) | |||
| copying an entire worksheet - need absolute values | Excel Worksheet Functions | |||
| Convert VLOOKUP to absolute cell reference | Excel Discussion (Misc queries) | |||
Threaded Mode
