Hello - Is it possible to create multiple if List.Contains?
I'm trying to create a rather large custom column with IFs ORs and ANDs...
if [Space] = "A" or [Space] = "B" or [Space] = "C" or [Space] = "D" or [Space] = "E" or [Space] = "G" or [Space] = "H" or [Space] = "I" or [Space] = "J" or [Space] = "K" or [Space] = "M" or [Space] = "N" or [Space] = "O" or [Space] = "P" or [Space] = "Q" or [Space] = "R" or [Space] = "S"and [Grade] >="9 (G9)" & [Grade] <="11 (G11)" then "$500" else if [Space] = "A" or [Space] = "B" or [Space] = "C" or [Space] = "D" or [Space] = "G" or [Space] = "H" or [Space] = "I" or [Space] = "J" or [Space] = "K" or [Space] = "M" or [Space] = "N" or [Space] = "O" or [Space] = "P" or [Space] = "Q" or [Space] = "R" or [Space] = "S" and [Grade] >="12 (G12)" and [Grade] <="14 (G14)" then "$750" else if [Space] = "A" or [Space] = "B" or [Space] = "C" or [Space] = "D" or [Space] = "G" or [Space] = "H" or [Space] = "I" or [Space] = "J" or [Space] = "K" or [Space] = "M" or [Space] = "N" or [Space] = "P" or [Space] = "Q" and [Grade] >="15 (G15)" and [Grade] <="17 (G17)" then "$1250" else ""
Hi Jennifer,
Better to use a lookup (merge tables): https://www.myonlinetraininghub.com/excel-power-query-vlookup
Or you can use List Functions: https://www.myonlinetraininghub.com/vlookup-using-dates-in-power-query-using-list-functions
Or if it's an approximate match: https://www.myonlinetraininghub.com/power-query-approximate-match-vlookup
Mynda
