Thread
:
VLOOKUP
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
Gary T[_2_]
external usenet poster
Posts: 1
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
Reply With Quote
Gary T[_2_]
View Public Profile
Find all posts by Gary T[_2_]