Thread
:
Return Value If Two Conditions occur
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
John Michl
Posts: n/a
Return Value If Two Conditions occur
How about...
In a column in Sheet2
IF(ISVALUE(Sheet1!B1),Sheet1!A1,"")
This will give you the name(s) if there is a number in column B. If
not, it will show a blank cell.
- John
Reply With Quote
Return Value If Two Conditions occur