match function with a variable starting row

[fab54]

Hello,
I would like to use the MATCH function on column A to find let's say the word "forum" but I would like the MATCH to start at the row given by cell B1
I was imagining something like
=MATCH("forum",Sheet1!A&"B1":A65000,0)
of course this doesn't work...

Thanks for your help.

F

 

[Richard Schollar]

Hi

You can use INDIRECT for this:

=MATCH("forum",INDIRECT("'Sheet1'!A" & B1 & ":A65000"),0)

 

[fab54]

Great, thx for your help!!