Formula to return a value from one column based on date in one col and no date in other

**Hedy** · 01-28-2020, 04:20 PM

I am attaching a sample spreadsheet to hopefully get some help on creating a formula as follows:

IN COLUMN U POPULATE THE WIDGET QUANTIY FROM COLUMN J WHEN COLUMN L HAS A DATE AND COLUMN N IS BLANK

IN COLUMN V POPULATE THE WIDGET QUANTITY FROM COLUMN J WHEN COLUMN N HAS A DATE AND COLUMN Q IS BLANK

I realize that probably one formula is needed for both - just tweak the columns in the formula.

Any help with this would be greatly appreciated. Thank you!

**Ace_XL** · 01-28-2020, 04:24 PM

In U2
=IF(AND(ISNUMBER(L2),N2=""),J2,"")

In V2
=IF(AND(ISNUMBER(N2),Q2=""),J2,"")

If you need a single formula try
=IF(OR(AND(ISNUMBER(L2),N2=""),AND(ISNUMBER(N2),Q2="")),J2,"")

Copy down

**Hedy** · 01-28-2020, 04:35 PM

This is perfect. Thank you!

Formula to return a value from one column based on date in one col and no date in other

LinkBack

Thread Tools

Rate This Thread

Display

Formula to return a value from one column based on date in one col and no date in other

Re: Formula to return a value from one column based on date in one col and no date in othe

Re: Formula to return a value from one column based on date in one col and no date in othe

Thread Information

Users Browsing this Thread

Similar Threads

Date formula to return a specific date if todays date is between a date range

Userform - User enters date into Textbox1, want Textbox2 to return a date based on formula

[SOLVED] Userform - User enters date into Textbox1, want Textbox2 to return a date based on formula

[SOLVED] Formula to automatically return date in correct cell based on date given

[SOLVED] Formula to enter a date in one column based on date in another

Excel 2007 : return a value based on column (date) and row headers (names)

Excel 2007 : Return Max Date in column based on lookup in adjacent column

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions