Excel Magic Trick #114: GetPivotData ISERROR and IF function

[PinjolliFundit]

Hey ExcelIsFun, how can I bring up a table done previously under the name Tab1,when I search it by the year that it corresponds? e.g - 2010 corresponds to Tab1.Write 2010 into the cell in order to bring up the Tab1 into another cell.Hopeless so far. Please help!DOes it make sense?

[ExcelIsFun]

I don't know a good way. Try the Mr Excel Message Board:

mrexcel[dot]com/forum

[PinjolliFundit]

@ExcelIsFun thnx man

[tumbaktu80]

Great stuff, Really useful....Many Thanks........

[ExcelIsFun]

Dear tumbaktu80,

I am glad that you liked it!

--excelisfun