IF function and VLOOKUP

Closed
Niobiy - Jun 8, 2010 at 11:47 PM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Jun 9, 2010 at 06:24 AM
Hello,

I have two questions

1. How to use IF function or any other if I want to return specific value only if cell has specific character, "-" for example.

2.Is any way to modify VLOOKUP function in case if there are two identical entries but with different parameters and to make it use second time second parameter For example

A 12
A 14

Thanks

1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
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
1