Looking up a value
Looking up a value
(OP)
I have info in a table and want to return a value based on two values. The first is located in the first column and the second is in the row that would be returned from the corresponding column.
I can use a match to return the the row to lookup in and should also be able to get the second value from a match as well, but haven't figured out how to force the second match to look in the correct row of the array based on the first value. Any thoughts?
I can use a match to return the the row to lookup in and should also be able to get the second value from a match as well, but haven't figured out how to force the second match to look in the correct row of the array based on the first value. Any thoughts?





RE: Looking up a value
You can find the code here. Credits are also on this page.
RE: Looking up a value
How about posting some sample data along with your expected result ... so we can see what you are working with and what you are trying to accomplish.
Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC
ANAND Enterprises LLC
http://www.energyefficientbuild.com
RE: Looking up a value
RE: Looking up a value