• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Making VLOOKUP recieve multiple formats of data

R

rajkiran

New Member
I have always been a frequent visitor and reader of your posts. Inspired by the same, I have done a project performance dashboard for my organization.

Currently am revisiting the dashboard to be more dynamic. In the process I am facing a slight problem. I am trying extract data from the database to a single cell using vlookup. Now the data is of different types like dates, percentages, numbers and text. But I am unable to make the cell receiving these data to have multiple formats. Can you please suggest on how to make a cell recieve different data types.

This will be of real great help.
 
Rajkiran


Firstly, Welcome to the Chandoo.org Forums


What is the range of each type of value do you normally see

eg:

% 20-50%

$ 2000 to 30,000

etc
 
Its about 20-50%.


Let me explain it in more clear way...I am trying to get attributes for calculation of different project management metrics in one table. For example..


If Users select "Effort Variance" Table which has two rows and 5 columns will dynamically change the its headers in the first row and its values for the project..i.e in header will show Planned Effort, Actual Effort, Cumm.Planned Effort Cumm.Actual Effort and Effort Variance

Second row will show its values for a particular project. These will be Numbers or %data

Now when User select Schedule Variance, Header will change to Planned Start Date, Planned End Date, Actual Start Date, Actual End Date and Schedule Variance. In the second row, while it is pulling SV values for a project, it shows in number or % format for dates. I want this to be shown as Dates and Numbers as Numbers.


I tried this using Conditional formats, like if value is SV, then format=dates but for EV, those numbers are getting displayed as dates. Please help.
 
I understand what you want to do

and so please What is the range of each type of value do you normally see

eg:

% from 20-50%

$ from 2000 to 30,000

Number from 10 to 1000

etc
 
Try applying this custom Number Format

select cells

Ctrl 1

Number

Custom

[<1]0.0%;[<10000]##,###;dd mmm yy
 
You must log in or register to reply here.
Back
Top