IF function and VLOOKUP
Closed
Niobiy
-
Jun 8, 2010 at 11:47 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 9, 2010 at 06:24 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 9, 2010 at 06:24 AM
Related:
- IF function and VLOOKUP
- Find function on mac - Guide
- Accessor function c++ - Guide
- Spreadsheet function - Guide
- Agp function - Guide
- Hard drive function - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 9, 2010 at 06:24 AM
Jun 9, 2010 at 06:24 AM
For question 1. You could use
=IF(A1="-", "found", B3")
instead of A1="-", you could try IsError(find(.....)) etc. More information is needed to give you exact answer, but I am sure you got the idea.
For 2nd, I think, if might be possible but just too hard and for sure slow. Coz first you have to do multiple scans to see if the things have been used before or not. If you post a sample file one may look at the data and see what can be suggested. You could on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc and post back here the link
=IF(A1="-", "found", B3")
instead of A1="-", you could try IsError(find(.....)) etc. More information is needed to give you exact answer, but I am sure you got the idea.
For 2nd, I think, if might be possible but just too hard and for sure slow. Coz first you have to do multiple scans to see if the things have been used before or not. If you post a sample file one may look at the data and see what can be suggested. You could on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc and post back here the link
