Check register with VLookup [Closed]

Question

Check register with VLookup [Closed]

Report

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: 2702
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: March 2, 2021

- 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

Check register with VLookup
Security checks preventing login - Forum - Facebook
Register as unemployed - How-To - Internet
How do i check my hotmail emails? - How-To - Hotmail
You cannot withhold your number check call settings ✓ - Forum - Mobile
Unsupported signal check device output ✓ - Forum - Laptop

1 reply

Ask a question

TrowaD · Answer 1 · 2017-07-13T11:51:02-0400

Answer 1 / 1

TrowaD

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

457
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

Check register with VLookup [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!