| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Search for & return list of values
I have a sheet with (6) columns and (306) rows. I would like to search for
empty cells in column (6) and return the values in columns {2, 3, 4 & 5}. And continue until the last row 308 is processed. For Example: G307 is empty returns B307 2643F C307 pg 2 of 3 D307 Orange E307 Friday = 2643F pg 2 of 3 Orange Friday The empty Cell is G308 B308 2643F C308 pg 3 of 3 D308 Orange E308 Friday = 2643F pg 3 of 3 Orange Friday Is there a non VBE/VBA solution? TIA, Phil |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search Column Data and Return Multiple Values across Row | Excel Worksheet Functions | |||
| Pulling multiple values from a list based on a wildcard search value? | Excel Worksheet Functions | |||
| search list for values | Excel Worksheet Functions | |||
| Search multiple values & return single value - seperate worksheets | Excel Worksheet Functions | |||
| Search multiple values to return single values | Excel Worksheet Functions | |||
Threaded Mode
