How do
I know if a Vlookup returns a value?
Select
cell B2, copy and paste formula =IF(ISNA(VLOOKUP(A2,$D$2:$D$185,1,FALSE)),
"No", "Yes") into the Formula Bar, then press the Enter
key. See screenshot: 2. Drag the Fill Handle down to the range you need
to vlookup and return yes or no.
Learn Excel
Formula's - https://exceljet.net/keyboard-shortcuts
Excel funtion to
truncate the column names to 29 characters + number if the name of the column
repeats
Macro to create
spaces in CamelCase names
<<Unity_Stage_Glossary_MACRO.xlsm>>
--Formula to rename
stage tables
=IF(EXACT(LEFT(F2),UPPER(LEFT(F2))),"BT_"&F2,"CT_"&F2)
how to get table
name from a string
=SUBSTITUTE(RIGHT(F2,LEN(F2)-3),"_Stg","")
how to match the
values of 2 cells (case sensitive)
=(EXACT(H2,I2))
How to Call a
Function in an Excel Cell
Overview - VBA in
Excel
CamelCase to
Snake_Case in Excel
No comments:
Post a Comment