| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Less i column
Hello from Steved
=IF(ISNA(VLOOKUP(D6,$S$2:$W$2000,5,FALSE)),"",VLOO KUP(D6,$S$2:$W$2000,5,FALSE)) Ok the above is fine it picks up the 5th column Col W Question is it possile to lookup the column to the left ie -1 =IF(ISNA(VLOOKUP(D6,$R$2:$V$2000,-1,FALSE)),"",VLOOKUP(D6,$R$2:$V$2000,-1,FALSE)) Thankyou. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Running total w/2 columns - Excel | Excel Worksheet Functions | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
| How to group similar column titles together???? | Excel Discussion (Misc queries) | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Threaded Mode
