Thread: Vlookup Problem
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Belinda7237 Belinda7237 is offline
external usenet poster
 
Posts: 106
Default Vlookup Problem

My Vlookup formula is:

=VLOOKUP(D81,'Week 2 Dataset'!G:O,9,0)

How would I write this differently so that when a result doesnt match i get
the cell to be left blank instead of #NA?

I need to incoprate an if but am not sure how to write it?

Thanks!