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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying absolute VLOOKUP
Just paste or grab the fill handle and drag down.
-- Don Guillett SalesAid Software "Martha" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying absolute VLOOKUP
Nope - doesn't work. Same result - It's copying the value instead of the
formula. Any other ideas? Thanks much "Don Guillett" wrote: Just paste or grab the fill handle and drag down. -- Don Guillett SalesAid Software "Martha" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying absolute VLOOKUP
Don - tried it and getting the same result. It's copying the value instead
of the formula. "Don Guillett" wrote: Just paste or grab the fill handle and drag down. -- Don Guillett SalesAid Software "Martha" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying absolute VLOOKUP
Make sure you recalculate (or set calculation to automatic)
tools|Options|calculation tab Martha wrote: 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 -- Dave Peterson |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying absolute VLOOKUP
Hi Martha,
It is copied across to 8 columns with the appropirate column reference entered twice in each one. what's your formula in the ninth cell. on the first row? When I copy the nine cells down, whats your formula in the ninth cell, on the last row? with that we can see what is your lookup value and column references. regards -- ***** birds of the same feather flock together.. "Martha" wrote: 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 |
Reply |
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) |