Looking up a value

[stumpsigpi]

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?

 

[UcfSE]

If I understand your question correctly, you can try vlookup2. It's a custom script that you add in to your excel files. It only works on a machine with the script installed, I forget what the file type is called. It's been a while since I bothered with it.

You can find the code here. Credits are also on this page.

 

[yogia]

Hi stumsigpi:

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

 

[quark]

thread770-173184, thread770-174397 if this is what you are looking for.

 

[stumpsigpi]

Thanks all. I was able to complete the task through the introduction of a choose function.