I am making a lookup table that needs to gather data from from another sheet, the data is as follows (an example)
Field API Value
Alright i have a term i want to search say "Large Dog"
I have a list of about 200 rows of files (located in a few main folders on my computer) that i want to search through each of the text strings.
Is there a way that i can search through the entire list and have the formula return return a...
I was hoping someone could help me with this. I have tried researching but am not getting anywhere...
Currently I am trying to do a vlookup, to see if I have booked in people for too many hours for any particular day (they are allowed 6 per day but it is tricky because they can be...