Thread: Problem with VLOOKUP and pivot table
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
LB79 LB79 is offline
external usenet poster
  
Posts: 1
Default Problem with VLOOKUP and pivot table

The formula im using is

=VLOOKUP(C5,$A$2:$B$50,2)

If I type actual data into C5 then it works, but if its pivot data it
just returns NA.


--
LB79
------------------------------------------------------------------------
LB79's Profile: http://www.excelforum.com/member.php...o&userid=12156
View this thread: http://www.excelforum.com/showthread...hreadid=565073

Reply With QuoteReply With Quote