vlookup problem

[fahadferoz]

Hi

There are two sheets in the attached file : Outlet wise due and Memo Tracker
I want to see Memo Tracker sheet's T column Data (Total) in Outlet wise due sheet's F column (Total Memo Numbers) based on the UID (column C).

I used Vlookup but cant get it done.

Any help would be highly appreciated.

Thanks!

 

[vletm]

1) T-column is 17th value, not 16th!
2) 'Memo Tracker' has duplicates in 'Customer Names'
=> You'll get the 1st value!

 

[fahadferoz]

there is no duplication in UID value. UID is Unique Identification Number, which is very unique to each outlet. Would you please let me know how should i do it? cause i have changed it to 16 but does not help. The formula i used is:

=VLOOKUP(C3,'Memo Tracker'!$D$3:$T$202,17,0)

Please help!

 

[vletm]

@fahadferoz
If You send this kind of case here ...

Then You are using 'Customer Name' from 'OUTLET WISE DUE' - Okay?

And for my eyes, there are duplicates - hmm?
>>
If You suddenly change 'formula' to other ...
=VLOOKUP(C3,'Memo Tracker'!$D$3:$T$202,17,0)
as VLOOKUP's syntax tells ... which column should be 1st - which?
D-column is still 'Outlet Name' or it that changed too?
for 1st column ... You'll count how many columns should go to right ... and so on
Questions?

 

[bosco_yip]

Try,

Changed your F3 VLOOKUP formula into :

=VLOOKUP(C3,'Memo Tracker'!$F$3:$T$202,15,0)

and copied down

p.s. Your E3 formula use C3 as criteria, so in F3 the VLOOKUP formula also use C3 as criteria.

Regards