Use the current row

[jak82]

Hi,

I have the following code

=IFERROR(IF(INDEX('Combined Page'!I:I,(MATCH('Load & Unload (7)'!A272,'Combined Page'!A:A,0)))>=35,"Completed","Available"),"")

Instead of having A272 I wanting to use A then row()

How would I write this?

Thanks

 

[steve the fish]

Hmm. Whatever row you have this formula in you change the 272 to that row number. What is your reason for doing anything else?

 

[jak82]

The user likes to move things about.

 

[jak82]

Using

ADDRESS(ROW(),COLUMN())

Returns the cell reference, how would I add that to my code?

 

[steve the fish]

Ive written a lot of spreadsheets in my time and i cant remember a time ive ever done this. However you can do what you want like this:

=MATCH(INDIRECT("'Load & Unload (7)'!A"&ROW()),'Combined Page'!A:A,0)

 

[jak82]

Works a treat thanks!