ok I think I have it

[ray in maur]

I named the data total.
=VLOOKUP(A2,total,2,FALSE)
this one seems to be working ok but I need to hide the total and put it in column IO that way if I need to insert column it wont delete the totals.

Cheers for you help

 

[Von Pookie]

Should this be a reply to your other thread?
http://www.mrexcel.com/board2/viewtopic.php?t=237584

 

[ray in maur]

yes

yes sorry I am new at posting these things sorry

 

[Von Pookie]

You should continue in that thread, then. Go to that thread, and either use the Quick Reply box towards the bottom of the page or click the Post Reply button to continue the conversation in that thread/page--as you obviously did here .