Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find a value, return the value of another cell
I need a formula for the following:
Given range BA2:BL2, I need to find the first value in this range 0, reading left to right, and then return the text in the corresponding cell in the range BA1:BL1. Example, if the first value 0 in the range BA2:BL2 is in BD2, I need the text in BD1 returned. Clear? I hope so. Thanks. Dave -- Brevity is the soul of wit. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct issues | Excel Worksheet Functions | |||
find a cell matching separate column and row values | Excel Worksheet Functions | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions | |||
up to 7 functions? | Excel Worksheet Functions |