Vlookup with Pivot table

[rentonhighlands]

Hello,
I want to use vlookup function. I want to lookup using data in a pivot table against data that is not in a pivot table. I tried and get #N/A error. Why?
I checked I see data in pivot table is the same data in my other sheet.
Is it that the formatting in the pivot table does not allow for vlookup to work?

 

[Peter_SSs]

VLOOKUP works fine in looking up values in a Pivot Table - see below.

If you cannot get it to work then it might be best to show us a small set of sample data, the resulting Pivot Table and a VLOOKUP formula or two (with the incorrect results) with XL2BB, similar to what I have done.
(If you have trouble with XL2BB, review the "XL2BB Icons greyed out" link in the 'Known XL2BB issues' section near the top of the XL2BB Instructions page linked above.)

25 02 24.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Name	Month	Amount			Sum of Amount	Month					Name	Amount
2	a	Feb	1			Name	Jan	Feb	Grand Total			b	14
3	c	Jan	4			a	3	4	7			a	7
4	a	Jan	3			b	8	6	14			c	13
5	b	Jan	2			c	4	9	13
6	b	Jan	5			Grand Total	15	19	34
7	b	Feb	6
8	c	Feb	7
9	a	Feb	2
10	a	Feb	1
11	b	Jan	1
12	c	Feb	2
Sample

Cell Formulas
Range	Formula
M2:M4	M2	=VLOOKUP(L2,F$3:I$10,4,0)

 

[rentonhighlands]

VLookup works to look up from data in pivot table to my other sheet for some lines but not for others. Can it be the way data if formatted in pivot table vs the format of data in my other sheet?
How can I check to see if the format is the same in both data sets?

 

[Peter_SSs]

Can it be the way data if formatted in pivot table vs the format of data in my other sheet?

Yes it can.

How can I check to see if the format is the same in both data sets?

It might depend on just what the data is like. The most common problem in this sort of situation is with data that is (or looks) numerical and it turns out one set of data is numerical and the other is text that looks like numbers.
To test that use the formula =ISNUMBER(xx) where xx is the cell address for one of the "numbers' in the pivot table and then do the same thing where xx is the cell address for one of the "numbers" in the other sheet.

If your issue is not related to numbers or text that looks like numbers, then review the section above the mini sheet in post #2 and also give us a small sample (also with XL2BB) from the other sheet.