Hi,
I took over a workbook that I am trying to decipher. I am specifically confused with the cell references such as $W$1 i the second VLOOKUP. I am used to seeing the number of columns but what does W1 reference? The sheet it is referencing doesn't have a column with data in W1. This whole formula is pretty complex but any help with breaking it down would be awesome.
Thank you!
=IF(AK5="Completed",VLOOKUP(AI$3&$A5,'SF Stage Current'!$A:$Z,8,0),IF(AK5="N/A","N/A",IF(VLOOKUP(AI$3&$A5,'SF Stage Current'!$A:$Z,$W$1,0)="",VLOOKUP(AI$3&$A5,'SF Stage Current'!$A:$Z,$S$1,0),VLOOKUP(AI$3&$A5,'SF Stage Current'!$A:$Z,$W$1,0))))
Bookmarks