Formula: like xllookup or Index/Match that uses two criteria.
If Sheet1 A2 is found in range Sheet2 A:A then return the cell in the range of Sheet2 $B:$IE that matches Sheet1 B$1
Formula: like xllookup or Index/Match that uses two criteria.
If Sheet1 A2 is found in range Sheet2 A:A then return the cell in the range of Sheet2 $B:$IE that matches Sheet1 B$1
Works great.
Works great but I am having a problem expanding it to the right and down. I have 886 rows down and a long way to the right.
Once you have tested the formula ... feel free to share your comments
Could you help me understand the formula a little better so I can expand it down to 886 rows and also many columns to the right?
Could you help me understand the formula a little better so I can expand it down to 886 rows and also many columns to the right?
Hello,
Two comments :
1. Did you see the message # 5 ... formula is already adjusted ...
2. To understand the mechanics of the combination Index / Match for a two-way lookup :
https://www.excel-easy.com/examples/two-way-lookup.html
Hope this will help
Don’t have an account yet? Register yourself now and be a part of our community!