finding row number and then color it.

[lezawang]

Hi
I have 2 columns, one has names and second has phone number. I will use Vlookup() to return the phone number if a user enter the name. That I can do but what else I want to do is to return the row number of that name and also Highlight the row corresponding to that name with different color. How can I do that? not the vlookup() part but for the finding row number and coloring the row. thanks you

 

[baitmaster]

Instead of using VLOOKUP, get in the habit of using INDEX(MATCH)

VLOOKUP is prone to errors which can be extremely hard to spot, e.g. if you insert a column. It also looks only one way, i.e. you look at column 1 and then return the value from column X. INDEX(MATCH) can look at any column and return the value from any other column

In your case you would replace e.g.
=VLOOKUP(A11,A1:A10,2,false)
with
=INDEX(B1:B10,MATCH(A11,A1:A10,0))

This also answers your questions, as the row number is found by the MATCH part of the formula, and you can use this value within Conditional Formatting