Question Locked

Excel Formula

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
What formula would work if I wanted to copy detailed from spreadsheets in a book identified by date and automatically copy the detail from specific cells on each dated spreadsheet into one column in a master spreadsheet?

2 replies

by thumbsup2

Either vLookup or hLookup should do the trick. But, you might need to add and IF or two.

If you give us more detail, we might be able to help more.

This discussion is closed to new replies.