Previous Topic Next Topic

Check register with VLookup

Closed
Jude2007 Posts 1 Registration date Friday July 7, 2017 Status Member Last seen July 7, 2017 - Updated on Jul 7, 2017 at 06:06 PM
TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 - Jul 13, 2017 at 11:51 AM
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

Answer 1 / 1
TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 541
Jul 13, 2017 at 11:51 AM
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
0