Thread
:
Copying absolute VLOOKUP
View Single Post
#
4
Posted to microsoft.public.excel.worksheet.functions
Martha
external usenet poster
Posts: 32
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
Reply With Quote
Martha
View Public Profile
Find all posts by Martha