Vlookup/hlookup

		Microsoft Office Forums > Microsoft Excel > Excel
Vlookup/hlookup

FAQ

Mark Forums Read

Thread Tools

Display Modes

10-14-2013, 08:49 AM

Ntema

Windows XP Vlookup/hlookup

Office 2007

Novice

Join Date: Oct 2013

Location: Gaborone , Botswana

Posts: 3

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

	October 2013.xls (238.5 KB, 12 views)
	GK_QTR4_BENCH_BY_BENCH test.xlsx (498.3 KB, 12 views)
	pv.xls (68.5 KB, 12 views)

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
HLOOKUP, if,? OR MACRO	bobbyarnold	Excel	22	01-14-2013 08:44 AM
IF and VLOOKUP	SBMC	Excel	1	11-07-2012 10:24 AM
HLOOKUP with VLOOKUP into different Doc	freeman	Excel	0	09-18-2012 02:04 PM
Vlookup	ibrahimaa	Excel	8	01-03-2012 09:32 PM
Vlookup	Karen615	Excel	4	09-12-2011 02:30 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:21 AM.