HELP with either VLOOKUP or Macro solution

[Francouk]

Hi,

Hope somebody out there can help, im trying to cut down on the amount of typing to complete the attached spreadsheet and would like to know the quickest/easiest way of copying the data to another location.

I need the "Issue 1, Issue 2 etc" from the overview tab to go into the corresponding section in tab 80. I can get this to work using the vlookup I have in cell A10 (on tab 80) but I need it to work so if I change the number in B5 (on tab 80) then the relevant information will pull through from the overview sheet.

Hope this makes sense and somebody out there can help me...

Regards

Craig

[arlu1201]

Will the order of the headers always be consistent?

[dangelor]

Try this formula in A10 and copy down...

=IF(ISERROR(VLOOKUP($E5,Overview,6,0)),"",VLOOKUP($E5,Overview,6,0))

[Francouk]

Thank you dangelor that has resolved my issue!!

I knew that there was a way just couldn't quite think of it.

Regards

Craig