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