# Reverse VLOOKUP

#### beanyboy7

##### New Member
Firstly, I would like to thank the various board admins, because they have been incredibly helpful with my minor excel dilemas.

The board admin helped me earlier with a VLOOKUP, I had forgotten how to properly use a VLOOKUP.

Anyway, I was wondering, how would you go about doing a reverse VLOOKUP.

For example, I have 2 lists. (L1 & L2)

List One is Names and phone #'s

List 2 is Names and Paymetn status

They look like this

List 1:
name: Phone:
Smith 555-0102
Jones 555-9811
Rodgers 555-8979
KIm 555-7875
Stanley 555-4513

List 2:
Name: Pay:
Smith Unpaid
York unpaid
Graves Paid
Rodgers Unpaid
Jones Paid
Kim Paid

Ok Know if I wanted to know which persons had phone #'s and weren't on the combine VLOOKUP list, (Stanley in the example). How would I go about doing that, some kind of Match Index string perhaps?

Also, If I wanted to create a list of who paid and doesn't have a phone # same question.

Thanks again you guys and this website are great. ray:

### Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.
Book1
ABCD
1List
2name:Phone:
3Smith555-01021
4Jones555-98111
5Rodgers555-89791
6KIm555-78751
7Stanley555-45130
8
9List
10Name:Pay:
11SmithUnpaid1
12Yorkunpaid0
13GravesPaid0
14RodgersUnpaid1
15JonesPaid1
16KimPaid1
Sheet2

where 0 == not in other list. will try to get back for your 2nd part but gotta go.

Replies
6
Views
1K
Replies
13
Views
1K
Replies
3
Views
15K
Replies
2
Views
374
Replies
2
Views
4K

1,203,101
Messages
6,053,536
Members
444,670
Latest member
laurenmjones1111

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back