tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 828084d1683213386-apply-a-formula-with-differing-criteria-based-on-a-referenced-cell-add_days_based_on_input-aligw
Sheet: Sheet1

category | original date | to be completed by date | [NAME] | AliGW
I | 2023-04-30 00:00:00 |  | B2+7
II | 2023-04-30 00:00:00 |  | B3+180
III | 2023-04-30 00:00:00 |  | B4+365
Spreadsheet: 50752d1250226900-help-with-conditional-formatting-nrcm-tracker
Sheet: Aco

NAME | [NAME] | BIRTH MONTH | CEF | BAMBI | APU QUAl | GUNNERY | [NAME] | UT
 |  |  | NO | YES
Burger, Brandon | RL1 D/N/NG |  | YES | NO
STINSMAN, CHRISTINA | RL 3 D/N/NG |  | NO | NO
CATES,JASON | [NAME] 3 NVG | OCTOBER | YES | YES
BULSON, JUSTIN | [NAME] |  | NO | NO
FAITH, CASEY A. | RL1 D/N/NG | OCTOBER | YES | YES
FRYER,GLENN | RL1 D/N/NG | APRIL | YES | YES
GALLAHER,STEVEN | RL1 D/N/NG | AUGUST | YES | YES
 |  |  | NO | NO
 |  |  | NO | NO
Fenner, [NAME] | RL1 D/N/NG | AUGUST | YES | NO
[NAME], [NAME] | RL1 D/N/NG | SEPTEMBER | YES | NO
MILLER,WILLIAM | RL1 D/N/NG | FEBUARY | YES | YES |  |  |  | SI
[NAME], [NAME] | RL 3 D/N/NG |  | NO | NO
KENNEDY, CHRISTOPHER | RL1 D/N/NG | AUGUST | NO | NO
Weaver, Justin | RL1 D/N/NG | JANUARY | YES | YES
WOOLHEATER,RICHARD | RL1 D/N/NG | NOVEMBER | YES | YES
ZASIMOVICH,VLADIMIR | RL1 D/N/NG | JULY | YES | YES
KILPATRICK,JEFFERY | RL1 D/N/NG | JULY | YES | YES |  |  |  | SI
MOORE, JUSTIN D. | RL1 D/N/NG | JANUARY | YES | YES
SANTANA, GEINER | RL1 D/N/NG | SEPTEMBER | YES | NO
Spreadsheet: 805759d1668894966-search-tab-for-specific-text-then-offset-from-the-cell-containing-that-text-example
Sheet: Master Data

 | Data Items
 | 1 | Data Item #1 |  |  |  | Goals:
 | 2 | Data Item #2 |  |  |  | I am trying to avoid any links between tabs because Fund Tabs will be added and removed to this workbook
 | 3 | Data Item #3 |  |  |  | This is why I first thought of using INDIRECT formulas
 | 4 | Data Item #4 |  |  |  | But given many users will use this workbook, I am trying to dummy proof it, in case the data sources are not in the same location in each workbook
 |  |  |  |  |  | My thought is to replace the formulas below with something like this:
 | Fund Name |  |  |  |  | search the Fund 1 tab for the cell that contains "transaction links", then offset a certain number of rows based on the number of the data item, and a certain number of columns based on the date
 | 1 | Fund 1
 | 2 | Fund 2
 | 3 | Fund 3
 | 4 | Fund 4
 | I WILL INPUT THE NAME OF FUND AND DATA ITEM HERE
 | Fund Name | Data Item |  |  |  | 2022-12-31 00:00:00
 | Fund 1 | Capital Calls
 | Fund 2 | Distributions
 | Fund 2 | Fees