Thread
:
blank cell return vs. a 0
View Single Post
#
5
Posted to microsoft.public.excel.worksheet.functions
GS[_2_]
external usenet poster
Posts: 3,514
blank cell return vs. a 0
Try...
=IF(LEN(A2),VLOOKUP(A2,Sheet1!A:BQ,3,FALSE),"")
--
Garry
Free usenet access at
http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.
vb
.general.discussion
Reply With Quote
GS[_2_]
View Public Profile
Find all posts by GS[_2_]