Search results 12

  2. Search results
  3. lookup
Card image cap
MatchIfUp or MatchIfRev

Searching for an item in a column from bottom to top. Will search for item in ...

Apr8
Card image cap
EdgarCIK

Search for company long name in Edgar and returns its CIK Using SEC.gov site ...

Feb25
Card image cap
VLookup_HTML

Does a search in 1st column (< td tag) in an HTML table (< table tag), and ...

Jan26
Card image cap
SearchinHTMLTable

Search for a word in a certain column in html table and return the full row ...

2023Nov12
Card image cap
HMatchIf_Multi

Returns column if an item from list of items was found in a row. Similar to ...

2023Oct30
Card image cap
ANmaVLookup

Finds first occurrence of item in column, then returns value from same row as ...

2022Dec23
Card image cap
CreateList_Matching

Creates list of items found in rows, where these rows match a value in another ...

2020May13
Card image cap
MatchLastIf

Finds last occurrence of a match in a column Finds the row of last time an ...

2019Jun12
Card image cap
VBInstr (or Instr parameters)

The great function InStr I use a lot has a small confusing part. Which string ...

2019Jan9
Card image cap
CellSave (SimpleSave)

Saves value to cell without deformation and converting Used to be called ...

2018Jun26
Card image cap
SettingRead_JR

Reads setting saved in columns J:R Just like SettingRead, but when we have ...

2018Jun26
Card image cap
CellRead (SimpleLookup)

Simply reading a value from a specific cell from a sheet from a workbook ...

2018Jun25