Thread: VLOOKUP
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary T[_2_] Gary T[_2_] is offline
external usenet poster
 
Posts: 1
Default VLOOKUP

I'm trying to find exact matches from Sheet 1 to Sheet 2, and to show a zero
value if there is no match. Can't seem to get the formula right...

=IFERROR(VLOOKUP($B13,Sheet2!$A$2:$A$298,3),0)

Any ideas?
Thanks