Forum Discussion
jwb92859
Jul 22, 2018Copper Contributor
Using a lookup with 3 arguments
H I folks, I have a task that I need help with. I have a large table that I want to search using something like VLOOKUP. But, I need to search three fields and return a value from a value. Attached ...
Detlef_Lewin
Jul 22, 2018Silver Contributor
Hi
=LOOKUP(9^99,D2:D28/(A2:A28=2)/(B2:B28=1)/(C2:C28=2))