Check register with VLookup [Closed]

Report
Posts
1
Registration date
Friday July 7, 2017
Status
Member
Last seen
July 7, 2017
-
Posts
2702
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
March 2, 2021
-
Check Register
Col.A Col. B Col.C Col H Col I
1 Payee Date payee Name Date paid
2 Victor 1-1-17 Victor 1-1-17
3 phone 1-5-17 phone 1-5-17
4 cable 1-10-17 light
5 Cable 1-10-17

Just show the day paid is a different column.

I have looked on line for months, and still cannot locate anything.
Hope you can help.
Here is what I think it is, but does not work.
=IF(B1:B5=VLOOKUP(H1:H5,3))

Thank you for your help.
Victor

1 reply

Posts
2702
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
March 2, 2021
457
Hi Victor,

I think you are looking for this formula:
=VLOOKUP(C2,$A$2:$B$5,2)

It will look for Victor (C2) in column A and then returns the value from column B (2nd column of the matrix A2:B5).

Best regards,
Trowa

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!