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



VLOOKUP, MATCH




HLOOKUP, MATCH




OFFSET, MATCH, MATCH





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