Forum Discussion
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 is simple sheet showing the problem.
Any help would be appreciated.
Thanks
Hi
=LOOKUP(9^99,D2:D28/(A2:A28=2)/(B2:B28=1)/(C2:C28=2))
Exactly what I needed!
Thanks 10^6- Greetings!
One more solution:
Formula
{=INDEX(D2:D28,MATCH(F11&G11&H11,A2:A28&B2:B28&C2:C28,0))}
Thanks,
