Link to home
Start Free TrialLog in
Avatar of javakit1969
javakit1969

asked on

IF condition false copy to other columns

I had this question after viewing Backup Tapes inventory excels function.

Hi Experts,

How we create a condition if the tapes not found,
then it will copy the other cells?

Thanks in advance
Javakit
tapeinventoryV1.xlsx
ASKER CERTIFIED SOLUTION
Avatar of Roy Cox
Roy Cox
Flag of United Kingdom of Great Britain and Northern Ireland image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of javakit1969
javakit1969

ASKER

Hi Roy_Cox

Thanks for the solution.
=IF(D:D="Not Found",B2,"")

Javakit
Avatar of Roy Cox
Roy Cox
Flag of United Kingdom of Great Britain and Northern Ireland image
Pleased to help
Avatar of javakit1969
javakit1969

ASKER

hi
I had follow the condition and copy down.
but it not copy the not found items
it just copy the last few cells.
Any solution for this ?

thanks in advance
javakit
Avatar of javakit1969
javakit1969

ASKER

hi

I mange use isnumber to solve the problem.

thanks
javakit
Avatar of Roy Cox
Roy Cox
Flag of United Kingdom of Great Britain and Northern Ireland image
I can't see why ISNUMBER was needed. If the cell in D is empty then there may be an issue. If this is the case try

=IF((OR(D2="Not Found",D2="")),A2,"")