Trying to create a "search" to go through a Google Sheet. There are technically two searches. The first one works as it should but the second has issues. Basically, I need the return of two values. So if I type "E" as the search key I need it to return 1 & 2. So far I can get it to pull 1 and thought I could use the return cell as the new search key. But it tells me it can't find 1.

For reference I used =VLOOKUP(A2,B5:C12,2,False) for 1st parameter and =HLOOKUP(B2,C5:C12,2,False) as second.

Image is obviously not the sheet I'm using but testing on a smaller scale.


1 Answer 1


Try this formula:


Sample sample

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.