vlookup formatting problem
Hi, i have a vlookup to a table that has both dates and percentages in. when i do a simple vlookup the data is fine but i cannot do conditional formatting. however, if i change the vlookup to this
=IF(VLOOKUP($E16,tblCurrent,5,FALSE)1,VLOOKUP($E1 6,tblCurrent,5,FALSE)*1,VLOOKUP($E16,tblCurrent,5, FALSE))
the conditional formatting works but anything that is a date becomes a percentage. so 11/26/13 becomes 4160400%
i tried using the text function for the last part of the formula but it didn't work
any ideas?
|