Thread: How to take the worksheet name as a variable(Label/Define) in a fo
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Subin
 
Posts: n/a
Default How to take the worksheet name as a variable(Label/Define) in
Thank you very Much.. Peo Sjoblom. It worked :-)


"Peo Sjoblom" wrote:

You can use indirect but your formula seems to test if B4 exists in G2:G245,
you can do that easier

=IF(ISNUMBER(MATCH(B4,INDIRECT("'"&I3&"'!G2:G245") ,0)),"Y","")

Reply With QuoteReply With Quote