Thread: eliminate N/A error when using Vlookup
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nena[_2_] Nena[_2_] is offline
external usenet poster
  
Posts: 20
Default eliminate N/A error when using Vlookup
How does this macro look? Will it give me a return of an "empty cell"?

ActiveCell.FormulaR1C1 = "=IF(ISNA(VLOOKUP(RC[-5],'Fall 2006 Cohort'!
R2C1:R65536C28,13,FALSE)=TRUE),"", VLOOKUP(RC[-5],'Fall 2006 Cohort'!
R2C1:R65536C28,13,FALSE))"
ActiveCell.Offset(0, 1).Select

THANKS!

Reply With QuoteReply With Quote