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

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

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

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

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

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

Copying absolute VLOOKUP
 

to drag, select the cellgoto the lower right cornergrab the square and
draglet go at desired point.
to copy copy select the cells to copy to editPASTE

--
Don Guillett
SalesAid Software

"Martha" wrote in message
...
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