Link to home
Start Free TrialLog in
Avatar of Seamus2626
Seamus2626Flag for Ireland

asked on

VBA Formula

Hi,

I havent entered formula ino the editor in a while

= VLOOKUP(B2,'Calculation D2'!A:BG,29,0)

Im getting an error with the apostrophy before calculation, can anyone advise?

Thanks
Seamus
ASKER CERTIFIED SOLUTION
Avatar of NBVC
NBVC
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Is the sheet 'Calculation D2' in the same workbook as the sheet in which you're trying to apply this formula?
Avatar of Seamus2626

ASKER

Thanks NB_VC