I am trying to do a vlookup and if combined. What I need is for a vlookup of a value as long as the row contains another value.
my formula I'm using is =IF(Sheet1!C:C=Sheet2!A1,VLOOKUP(SheetB2,Sheet1!G:S,13,FALSE))
I need to lookup what column S shows on Sheet 1 if column G of Sheet 1 matches the value of Sheet 2 cell B2, however I want it to only pull from rows in Sheet 1 that contain a certain in text in the C column (used A1 as a reference for this). As there are repeating values of cell B2 in the G column depending on what the column C criteria is. The formula I currently have just displays FALSE when entered.
PS Sorry for not having the mini-sheet upload. Not able to download external software on work computer. Thanks.
my formula I'm using is =IF(Sheet1!C:C=Sheet2!A1,VLOOKUP(SheetB2,Sheet1!G:S,13,FALSE))
I need to lookup what column S shows on Sheet 1 if column G of Sheet 1 matches the value of Sheet 2 cell B2, however I want it to only pull from rows in Sheet 1 that contain a certain in text in the C column (used A1 as a reference for this). As there are repeating values of cell B2 in the G column depending on what the column C criteria is. The formula I currently have just displays FALSE when entered.
PS Sorry for not having the mini-sheet upload. Not able to download external software on work computer. Thanks.