ISTEXT ()
This function examines a cell to determine whether it is a text
value.
|
|
A |
B |
C |
D |
|
1 |
Cell Entry |
Result |
||
|
2 |
1 |
FALSE |
=ISTEXT(A2) |
|
|
3 |
20-Jan-21 |
FALSE |
=ISTEXT(A3) |
|
|
4 |
|
FALSE |
=ISTEXT(A4) |
|
|
5 |
#DIV/0! |
FALSE |
=ISTEXT(A5) |
|
|
6 |
Hello |
TRUE |
=ISTEXT(A6) |
|
|
7 |
#VALUE! |
FALSE |
=ISTEXT(A7) |
|
|
8 |
If the cell or calculation is a text value the result TRUE is shown.
If the cell is blank, the result FALSE is shown.
If the cell or calculation is an error, the result FALSE is shown.
Syntax
=ISTEXT (Cell)
Formatting
No
special formatting is needed.
Example
Below
table has employee data like Emp ID, Emp Name, Salary, and Email. Sometimes operator
search details with Emp ID and sometimes with Emp Name.
So
ISTEXT() function is used to
determine input cell whether the value is EmpID or Emp Name. And then IF() Function used to swap VLOOKUP() function.
|
|
A |
B |
C |
D |
E |
F |
|
12 |
column_1 |
column_2 |
column_3 |
column_4 |
||
|
13 |
Emp ID |
Emp Name |
Email ID |
Emp Salary |
||
|
14 |
810 |
Neeraj |
neeraj.kumar@gmail.com |
₹ 65,000 |
||
|
15 |
898 |
Syed |
syed.azam@gmail.com |
₹ 72,000 |
||
|
16 |
941 |
Rahul |
rahul.yadav@gmail.com |
₹ 53,000 |
||
|
17 |
986 |
Andrew |
andrew.shulman@gmail.com |
₹ 98,000 |
||
|
18 |
722 |
Brandan |
brandan.jeorge@gmail.com |
₹ 85,000 |
||
|
19 |
701 |
Vijay |
vijay.yadav@gmail.com |
₹ 91,000 |
||
|
20 |
969 |
Saif |
saif.ali@gmail.com |
₹ 65,000 |
||
|
21 |
967 |
Ryan |
ryan.jourdan@gmail.com |
₹ 82,000 |
||
|
22 |
885 |
Matthew |
matthew.boltz@gmail.com |
₹ 78,000 |
||
|
23 |
748 |
Akshay |
akshay.kumar@gmail.com |
₹ 69,000 |
||
|
24 |
||||||
|
25 |
Employee Name or ID |
748 |
||||
|
26 |
Employee Email ID |
akshay.kumar@gmail.com |
||||
|
27 |
Employee Salary |
₹ 69,000 |
||||
|
28 |
=IF(ISTEXT(C25),VLOOKUP(C25,B13:C23,2,0),VLOOKUP(C25,A13:C23,3,0)) |
|||||
|
29 |
=IF(ISTEXT(C25),VLOOKUP(C25,B13:D23,3,0),VLOOKUP(C25,A13:D23,4,0)) |
|||||
|
30 |
||||||
The ISTEXT()
function has been used to identify the type of entry made, and then
The IF() decides
which VLOOKUP to perform.
In the above example, we have entered Emp ID, and on the
basis of that result is showing. If you will enter Emp Name then it will swap VLOOKUP
to perform.
No comments:
Post a Comment