L leeshan New Member Joined Jan 27, 2013 Messages 24 Mar 20, 2013 #1 for eg, VLOOKUp and HLOOKUP helps us to look up for value. now i want to match the sparkline, as in lookup the sparkline for a particular region for example then display it in another tab. What formula should i use? Thanks a lot!!!!