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
![]() |
© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited TopPrevNext