Another common non-macro approach:
Insert a new column A. In it, concatenate the cells in each row of columns B
& C (which used to be A & B). Put this formula in A2
=B2&C2
and copy down. Now you can do a normal Vlookup in D9 (which used to be C9):
=VLOOKUP(A9,$A$2:$D$4,4,FALSE)
Copy down, recalc, and copy/paste in place as values. Then you can delete
the new column A and use Edit Replace to replace the #N/A with nothing. To
avoid #N/A from the start, use this formula in D9:
=IF(ISERROR(VLOOKUP(A9,$A$2:$D$4,4,FALSE)),"",VLOO KUP(A9,$A$2:$D$4,4,FALSE))
Hutch
" wrote:
Here's the spreadsheet I'm working on:
http://www.myfootsmells.com/excel/copypaste.xls
I want to copy from A2:C4 and then put my cursor in C9 do a paste and
it'll fill in the hours accordingly. Possible? It doesn't need to be
a paste, I'd be find putting my cursor in C9 and pressing a button on
the page.
Thanks,
Michael