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.