Thread: LOOKUP follow up (pull only specific column)

figured will post the formula I use... beating my head into the wall still trying to figure this out...

I need to figure out how to only LOOKUP values for the column 13 city "NEW YORK" but ignore all others

 Set rng = Nothing
    On Error Resume Next
    With Sheets("data")
    Set rng = .Range("K2:K" & LastRow2).SpecialCells(xlCellTypeBlanks)
    On Error GoTo 0
    If Not rng Is Nothing Then rng.FormulaR1C1 = _
    "=IF(ISNA(LOOKUP(2,1/(RC1='previous day'!R8C1:R" & LRDat2 & "C1)/(RC3='previous day'!R8C3:R" & LRDat2 & "C3)/(RC8='previous day'!R8C8:R" & LRDat2 & "C8),'previous day'!R8C11:R" & LRDat2 & "C11)),""1"",LOOKUP(2,1/(RC1='previous day'!R8C1:R" & LRDat2 & "C1)/(RC3='previous day'!R8C3:R" & LRDat2 & "C3)/(RC8='previous day'!R8C8:R" & LRDat2 & "C8),'previous day'!R8C11:R" & LRDat2 & "C11)+1)"
    Set rng = .Range("K2:K" & LastRow2)
    rng.Value = rng.Value
    End With
End Sub

just bumping this up.. if anyone has some input would very much appreciate it.. really stuck on this part on finishing the project and need some help... thanks so much