Sleepingsouls
New Member
- Joined
- Jan 22, 2018
- Messages
- 20
Hi Guys,
Having a little trouble with a look up I have tried Vlookup with no luck and I have Tried Index Match... But I think I'm missing something important - or at least not getting it exactly right.
<colgroup><col><col><col><col><col span="3"></colgroup><tbody>
</tbody>
<tbody>
</tbody>
Having a little trouble with a look up I have tried Vlookup with no luck and I have Tried Index Match... But I think I'm missing something important - or at least not getting it exactly right.
A | B | C | D | E | F | |
1 | First Name | Last Name | ID | |||
2 | John | Smith | 1 | Search | ||
3 | James | Samuels | 2 | ID | ||
4 | Jacky | Grant | 3 |
<colgroup><col><col><col><col><col span="3"></colgroup><tbody>
</tbody>
What I want to be able to do is search for either column A or B and return C as the result - So if I type in John it will return 1 or if I type in Smith it will return 1. Thank you. | |||||
<tbody>
</tbody>
Last edited: