Vlookup not returning correct values

In my worksheet, I am using a vlookup function and referencing a table array from another sheet. I am attempting to match payment receipts with the correct property/tenant (from my second sheet). I have moved my reference column to the first column on the second worksheet (tenant name; column A and property number; column b) and am looking for a return a value on my new document that matches the tenant name but the result displayed is the property number. Here is the formula I am using
=VLOOKUP(G4&"*",'[Copy of Tenant Lookup List 2016 - JAKE.xlsx]Sort- Pay From'!$A$2:$C$1963,2,TRUE)

Although I am getting property numbers as a result the property numbers are not from the correct tenant.

What should I change or do to have excel return the right property number from my second sheet?

Let me know if i need to be more clear!

Thanks

Can you share an example workbook for this please?

Date Charge Notes Property Result of Formula
42533 10 NORTHWEST 0919192 =VLOOKUP(C2&"*", Sheet1!A2:B15,2,TRUE) 689-200
42534 10 SMALL1560201 =VLOOKUP(C3&"*", Sheet1!A3:B16,2,TRUE) 688-550
42535 10 SH292932 =VLOOKUP(C4&"*", Sheet1!A4:B17,2,TRUE) 689-200
42536 10 SOL2593226 =VLOOKUP(C5&"*", Sheet1!A5:B18,2,TRUE) 689-200
42537 10 MAR261426 =VLOOKUP(C6&"*", Sheet1!A6:B19,2,TRUE) 689-199
42538 10 252621 HELLEN S =VLOOKUP(C7&"*", Sheet1!A7:B20,2,TRUE) # N/A
42539 10 BRUN2516226 =VLOOKUP(C8&"*", Sheet1!A8:B21,2,TRUE) #N/A
42540 10 1516263SOLUTIONS =VLOOKUP(C9&"*", Sheet1!A9:B22,2,TRUE) #N/A
42541 10 CHRY 162265 =VLOOKUP(C10&"*", Sheet1!A10:B23,2,TRUE) 689-120
42542 10 SECURE CORP 2516246 =VLOOKUP(C11&"*", Sheet1!A11:B24,2,TRUE) 689-200
42543 10 AAA 516265 =VLOOKUP(C12&"*", Sheet1!A12:B25,2,TRUE) 689-120
42544 10 NET151621 =VLOOKUP(C13&"*", Sheet1!A13:B26,2,TRUE) 689-200
42545 10 INSTAN 156265 =VLOOKUP(C14&"*", Sheet1!A14:B27,2,TRUE) #N/A
42546 10 MGMT 14161516 =VLOOKUP(C15&"*", Sheet1!A15:B28,2,TRUE) 689-200

Notes include part of the tenant name but not entire name

Try changing TRUE to FALSE
And locking the lookup range with $

=VLOOKUP(C2&"*", Sheet1!A$2:B$15,2,FALSE)

When changing true to false I only receive the #NA message... I also delete the wildcard when changing to false

KEEP the wildcard, use FALSE.

Also did this, but continue to get the N/a

Can you attach a sample workbook?

I am trying to add an attachment.

The actual notes have a bit more to them but sensitive information

We need to see the lookup table as well ('H:\Accounting\Jacob Jennings\[Copy of Tenant Lookup List 2016 - JAKE.xlsx]Sort- Pay From'!$A$2:$C$1963)

Can you copy that into another sheet on the same book, and write your formula referring to that.

Sheet four is the tenant look up list

It doesn't appear to be

You have in T2 on Sheet3
=VLOOKUP(G2&"*",'H:\Accounting\Jacob Jennings\[Copy of Tenant Lookup List 2016 - JAKE.xlsx]Sort- Pay From'!$A$2:$C$1963,2,FALSE)

I put this in U2
=VLOOKUP(G2&"*",Sheet4!$A$2:$C$1963,2,FALSE)

I don't get the same results you have from the original formula in U.
I get nothing but #N/A.

ok, so looking at the data (forget the formula for now..)

Sheet3!G2 = "WIRE IN GGT GUARDIAN"

Which cell on Sheet4 is that supposed to be a match with ?