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 ...
pranav trikha
Jul 23, 2018Brass Contributor
Greetings!
One more solution:
Formula
{=INDEX(D2:D28,MATCH(F11&G11&H11,A2:A28&B2:B28&C2:C28,0))}
Thanks,
One more solution:
Formula
{=INDEX(D2:D28,MATCH(F11&G11&H11,A2:A28&B2:B28&C2:C28,0))}
Thanks,