Please Help!!
I've been mucking around for hours, but can't seem to get anything to work correctly.
What i need to do is match a single value, but this value could be in a number of different columns, please refer the below:
<tbody>
</tbody>
For example I need to lookup the associated value of "r" but need to search all columns, as this will be user input cell.
Does this make sense? can anyone help?
I've been mucking around for hours, but can't seem to get anything to work correctly.
What i need to do is match a single value, but this value could be in a number of different columns, please refer the below:
Col A | Col B | Col C | Col D | Col E | Col F | |
Row 1 | a | 1 | h | 8 | o | 15 |
Row 2 | b | 2 | i | 9 | p | 16 |
Row 3 | c | 3 | j | 10 | q | 17 |
Row 4 | d | 4 | k | 11 | r | 18 |
Row 5 | e | 5 | l | 12 | s | 19 |
Row 6 | f | 6 | m | 13 | t | 20 |
Row 7 | g | 7 | n | 14 | u | 21 |
<tbody>
</tbody>
For example I need to lookup the associated value of "r" but need to search all columns, as this will be user input cell.
Does this make sense? can anyone help?