| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy from Two Cells
Thank you to all 4 who answered. Problem solved.
"Ragdyer" wrote: Try this: =IF(AND(ISNA(A1),ISNA(B1)),"N","Y") -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Steve B" wrote in message ... Hello, I have two columns, each with a Vlookup to seperate spreadsheets. Each column will have either a "Y" or and #NA."Y" represnting that a client has enrolled in a meeting, #NA from Vlookup in either one or both columns if the client has not enrolled in either meeting. So I want a third column to have a "Y" if there is a "Y" either coluimn A or B in the same row.(or conversly a "N" if there is not a Y in either column Thank you in advance for saving me from pulling anyu more hair out. Help here is always terriffic. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
| How do I fill (copy) nonadjacent cells to adjacent cells? | Excel Discussion (Misc queries) | |||
| how can we copy cells comments text and paste to cells | Excel Discussion (Misc queries) | |||
| How to use macros to copy a range of cells which can exclude some cells which I didn't want to be copied? | Excel Worksheet Functions | |||
| Copy cells into range of cells until cell change | Excel Worksheet Functions | |||
Hybrid Mode
