Another one:

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

If you're using Excel 2007:

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

Note that this will trap *all* errors, not just #N/A.


--
Biff
Microsoft Excel MVP


"Belinda7237" wrote in message
...
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!