copying data to relevent cells

**stevekirk** · 09-17-2006, 09:06 AM

hi,

i am trying to copy data from one cell to another but the cells are tied in with other cells with information in them
i want to use a macro to do this if possible
could you please look at the attached spread sheet as this my be more explanatory

thanks steve

**davesexcel** · 09-17-2006, 09:18 AM

=IF(ISERROR(VLOOKUP(A5:B5,$A$14:$C$16,3,0)),"",(VLOOKUP(A5:B5,$A$14:$C$16,3,0)))

this is an array formula, once you have it in place.. ctrl shift enter for it to work

**stevekirk** · 09-17-2006, 01:41 PM

hi

i am new to array,s .
i have copied ths formular to the the cells where i want the results which is column C and i cannot get the results .but if i put the formula in column a i do

could you please tell me what i am doing wrong

thanks

steve

**starguy** · 09-18-2006, 07:06 AM

here is the implemented file
press Ctrl+Shift+Enter rather Enter

**davesexcel** · 09-18-2006, 07:18 AM

Steve place this formula in C5
=IF(ISERROR(VLOOKUP(A5:B5,$A$14:$C$16,3,0)),"",VLOOKUP(A5:B5,$A$14:$C$16,3,0))

then hit F2 to be in the formula bar
press Ctrl SHift Enter to get the formula to work
copy the formula down the column
here's your sheet back