Two Way Lookup

This assumes you want to cross reference by using a value in the first column and a value in the first row.
There are a number of ways to do this.


INDEX, MATCH, MATCH


alt text

VLOOKUP, MATCH


alt text


HLOOKUP, MATCH


alt text


OFFSET, MATCH, MATCH


alt text



© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited TopPrevNext