0 or 1 Based
Everything is zero based.
worksheet.cells(1,1) is the first cell in VBA and C#.
Worksheet function arguments however will be 1-based for consistency purposes.
vlookup("blue",A1:D10",2) will return the value from the second column
Likewise the result from the Match function will be 1 based.
© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited TopPrevNext