![]() |
#7
|
||||
|
||||
![]()
If you use the "Evaluate Formula" tool in the Formulas tab, you can step through to see what's happening.
The Search() part does what you expect and is seaching for any of the B1:B5 entries in A1. The 1/ part converts any entries to values of 1 or less and leaves errors as errors. The Lookup(2.. part looks for the last time that a value of 2 or less is found in the result array, and it then aligns it to the location with B1:B5 to return the corresponding result. |
Tags |
=if, =match, =search |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
bishweshwar | Excel | 3 | 03-13-2017 10:07 AM |
Expanding a formula bug on Mac's Excel | Bouss | Excel | 0 | 01-27-2017 06:22 PM |
Prevent cell from expanding vertically. | snowboarder2 | Word Tables | 1 | 08-24-2016 02:52 PM |
![]() |
Dkline | Excel | 3 | 06-04-2014 06:40 AM |
How to prevent Tables from expanding | HappyFingers | Word | 1 | 11-29-2010 01:54 PM |