I would like to build a formula that is user proof.
I have tapped this out;
=INDEX(BusTable,MATCH(Q5,BusNo,0),2) and it works fine. This is in cell R5.
In an attempt to replace all direct cell references I have written this;
<tbody>
</tbody>
but is returning a #N/A because of the address part. I have the wrong syntax.
How do I fix this?
Thanks for any help
I have tapped this out;
=INDEX(BusTable,MATCH(Q5,BusNo,0),2) and it works fine. This is in cell R5.
In an attempt to replace all direct cell references I have written this;
=INDEX(BusTable,MATCH((ADDRESS(ROW(),COLUMN()-1))),BusNo,0),2) |
<tbody>
</tbody>
but is returning a #N/A because of the address part. I have the wrong syntax.
How do I fix this?
Thanks for any help