You’re doing something that is very simple using Firebase and instead making it very complicated. You have every right to do that but it makes helping you difficult.
It sounds like you might want to do a VLookup. That’s where you find a value in a row and then return a different column value from that same row. If so, you can search the forums for “vlookup” to find examples of how to do that. Here’s a good example: Thunkable and returns a corresponding value from my sheet - #7 by blvckrosesssppi
·····················································································································
Need help? How to Ask Great Questions 
Debugging A Project API JSON Tutorial
Want to hire a Certified Thunkable Expert? Elevate your app with Tatiang on Fiverr