Software

Ask something
Question Locked

Excel IF Function

0 helpful
4 replies

by dcote320

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am trying to extract text from a worksheet within the same workbook to create a summary worksheet. In using the below formula, if the reference cell is not on the same row in both worksheets, the formula stops working on that respective row and all below rows. How can I correct this?

=IF('CIV-VACANT DETAIL'!$D:$D=$D15,'CIV-VACANT DETAIL'!$J:$J,"")

4 replies

by absolutely

The 'vlookup' function might help, too, but would probably require an intermediate step or two.

by dcote320

The absolute and relative reference changes didn't do anything for me. However, I figured out how to use VLOOKUP and ISBLANK. I only had to make sure the primary reference data I was looking for was hidden in column A while primarily residing in another column for me to view logically.

This discussion is closed to new replies.