Hello, Can anyone explain why Lookup does not work with the second function but does with the first? When I evaluate the wrong formula, the lookup value matches a value in the lookup array, but produced #N/A anyway.
Correct formula: =LOOKUP(1, 1/(F3&G3=C3:C12&D3:D12), B3:B12)
Wrong formula: =LOOKUP(F3&G3, C3:C12&D3:D12, B3:B12)
When I look up D.M. and QFC, the wrong formula gives me an #N/A. When I look up Tacoma and QFC, I get Mo with the wrong formula, when it should be Phil. With the other cities I get an #N/A.
Thanks for any help.
Bookmarks