Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

VBA Conversion Question - MATCH

Hi, I am converting an Excel sheet to LibreOffice. I have the following line of code that works beautifully to determine the row where a specific mileage is found (or the row after if no exact match is found).

offnbr = Application.Match(nbr, Range("a5:a1515"), 1)

I see INDEX ... MATCH used on this site but cannot seem to get the syntax right. I currently have

Spot = INDEX($B$5:$B$1515,MATCH(nbr,$A$5:$A$1515)

I gather that this will find nbr in column A and return the corresponding value in column B, same row. Am I understanding correctly?