lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hi
I want to know if Vlookup or Xlookup can return to me the cell location or highlight the cell for me. I am just experimenting Vlookup function. Here in the example below, if the user enter a name and it was a match then Vlookup will highlight the name in the column for example? Is that possible? Thank you very much.
I want to know if Vlookup or Xlookup can return to me the cell location or highlight the cell for me. I am just experimenting Vlookup function. Here in the example below, if the user enter a name and it was a match then Vlookup will highlight the name in the column for example? Is that possible? Thank you very much.
| Book1 | |||||||
|---|---|---|---|---|---|---|---|
| A | B | C | D | E | |||
| 1 | Name | Enter Name | #N/A | ||||
| 2 | Mary1 | ||||||
| 3 | John1 | ||||||
| 4 | Alex1 | ||||||
| 5 | Sarah1 | ||||||
| 6 | Anna1 | ||||||
| 7 | Mary2 | ||||||
| 8 | John2 | ||||||
| 9 | Alex2 | ||||||
| 10 | Sarah2 | ||||||
| 11 | Anna2 | ||||||
| 12 | Mary3 | ||||||
| 13 | John3 | ||||||
| 14 | Alex3 | ||||||
Sheet1 | |||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| E1 | E1 | =VLOOKUP(D1,A2:A14,1,FALSE) |
