K
Karl Burrows
I am trying to consolidate workbooks and there are several that reference a
lot number (real estate company). Each workbook contains different data for
the same lot (closing dates, homeowners, etc.). I have copied them all into
one workbook and am trying to create a formula that will look at the other
worksheets to match the lot number on the first worksheet and add values
from the same row. For example, if I already have a lot #100 on the main
page I have created, I want to look at the other worksheet and if there is a
lot #100, return the value in another column on the same row that adds the
closing date to the first worksheet.
Can it be done? I have tried an array, but I am not adding or counting
anything, I just need the value.
Thanks!
lot number (real estate company). Each workbook contains different data for
the same lot (closing dates, homeowners, etc.). I have copied them all into
one workbook and am trying to create a formula that will look at the other
worksheets to match the lot number on the first worksheet and add values
from the same row. For example, if I already have a lot #100 on the main
page I have created, I want to look at the other worksheet and if there is a
lot #100, return the value in another column on the same row that adds the
closing date to the first worksheet.
Can it be done? I have tried an array, but I am not adding or counting
anything, I just need the value.
Thanks!