Posted to microsoft.public.excel.worksheet.functions

[email protected] pbuscio@comcast.net is offline

external usenet poster

Posts: 4

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Vlookup problem - unable to get the vlookup property	Fred	Excel Programming	2	August 22nd 08 05:23 PM
Vlookup and formatting	Prixton	Excel Discussion (Misc queries)	2	April 25th 08 06:25 PM
VLookup & Formatting	Janet	Excel Discussion (Misc queries)	5	January 15th 07 03:49 PM
Need Help w/ VLookup Formatting	Mike Lindsay	Excel Worksheet Functions	10	May 5th 06 02:03 AM
Vlookup and Formatting	peter_rivera	Excel Discussion (Misc queries)	2	July 11th 05 07:24 PM

All times are GMT +1. The time now is 05:37 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us