Help Please

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using the following formula
=VLOOKUP(T2,$A$711:$P$782,13,1

The value that is returned is in the form ###/###. I would like to strip the /### from the returned value so I can compare it to another cell. Example....Lookup returns 100/100. Through conditional formatting I would like to compare it to the value entered in t4, and change font color if they are not the same

Thanks a million!
 
No need to strip the data.

Assume the value is returned in T5. In Format/Conditional Formatting

CF1: Formula is =LEFT(T5,FIND("/",T5)-1)*1 <> T4


Omit the "*1" if the value in T4 is Text.
 
For conditional formatting, you can refer to the cell (F17 in this example)
and compare it to T4 using this formula within conditional formatting:
=--LEFT(F17,FIND("/",F17)-1)<>T4

Or this to return the number portion of the Vlookup, for eyeball, or
condtional formatting comparison with the formula F17<>T4 (as an example).

=--LEFT(VLOOKUP(T2,$A$711:$P$782,13,1),FIND("/",VLOOKUP(T2,$A$711:$P$782,13,
1))-1)

that formula should do the trick, though since I dont have the ranges I
wasn't able to test it very much.



Gene said:
I am using the following formula:
=VLOOKUP(T2,$A$711:$P$782,13,1)

The value that is returned is in the form ###/###. I would like to strip
Click to expand...
the /### from the returned value so I can compare it to another cell.
Example....Lookup returns 100/100. Through conditional formatting I would
like to compare it to the value entered in t4, and change font color if they
are not the same.
 
Back
Top