Thread: [Solved] Vlookup/hlookup
View Single Post
 
Old 10-14-2013, 08:49 AM
Ntema Ntema is offline Windows XP Office 2007
Novice
  
Join Date: Oct 2013
Location: Gaborone , Botswana
Posts: 3
Ntema is on a distinguished road
Default vlookup
hi,

I have managed with PivotTable. It is not a mistake it is how I arrange my tables. See attached file. GK_QTR4_BENCH_BY_BENCH test, PV

I have worked out another VLookup. On my truck factor material where material is "Fresh" I get a #N/A. When i change the material type to either "Soft or Transitional" the result is the correct result...see file October 2013
Attached Files
File Type: xls October 2013.xls (238.5 KB, 12 views)
File Type: xlsx GK_QTR4_BENCH_BY_BENCH test.xlsx (498.3 KB, 12 views)
File Type: xls pv.xls (68.5 KB, 12 views)
Reply With Quote