Creating a Chart/table with with available set of data

**resiexfor** · 03-13-2018, 04:01 PM

Hello everyone,
I'm trying to get this final result.
iv-drug-incompatibilities-19-638.jpg

I have the data for each individual drug, but it would be painful to do it one by one,
Can excel speed up the process somehow?

Hope you can give me some pointers.

Thanks alot.

**AliGW** · 03-13-2018, 04:46 PM

Have a look here: https://www.excelforum.com/excel-for...e-of-data.html

**resiexfor** · 03-14-2018, 12:28 PM

Originally Posted by AliGW

Have a look here: https://www.excelforum.com/excel-for...e-of-data.html

Thanks for the link, but i think my case is different!
I'm having multiple tables of drug compatibility and i'm not trying to count the occurances, but i'm trying to find the value corresponding to each drug.
Ive tried vlookup but couldn't figure i out to work
can you please take a look at the updated sample? and tell me of a why to return the data of each cell?! and ignoring errors as well?

Thanks alot in advance.

**ANGIE90** · 03-14-2018, 03:21 PM

Hello,

Please see attached. I hope this works for you.

**resiexfor** · 03-15-2018, 04:58 AM

Thanks for that.
It did exactly what i wanted.
thread resolved

**AliGW** · 03-15-2018, 05:31 AM

Angie90 - for the benefit of all here, please give some explanation of the solution you have offered in your post. Have a look at the link I posted above to see the sort of thing I mean (where I offered a solution). Thank you.

**ANGIE90** · 03-15-2018, 02:01 PM

Hi Ali,

I tried to reply to your private message, but I don't think it went through.

I simply used the INDEX/MATCH function here to return the values and used IFERROR to cover up the #N/A error messages. I'm new to the forum and not an advanced user of Excel. I don't think I can explain the INDEX/MATCH function clearly. I would appreciate your help on this.

Deskbright.com has a very useful and detailed tutorial on INDEX/MATCH. Sorry I can't post the link here.

**AliGW** · 03-15-2018, 02:09 PM

We don't need a link. What is the actual formula that you used? Post that here, please.

I replied to your message about five minutes ago.

**ANGIE90** · 03-15-2018, 02:12 PM

=IFERROR(INDEX(Table3[#All],MATCH(Sheet6!B1,Table3[[#All],[COMP WITH MED10]],0),1),"")

Creating a Chart/table with with available set of data

LinkBack

Thread Tools

Rate This Thread

Display

Creating a Chart/table with with available set of data

Re: Creating a Chart/table with with available set of data

Re: Creating a Chart/table with with available set of data

Re: Creating a Chart/table with with available set of data

Re: Creating a Chart/table with with available set of data

Re: Creating a Chart/table with with available set of data

Re: Creating a Chart/table with with available set of data

Re: Creating a Chart/table with with available set of data

Re: Creating a Chart/table with with available set of data

Thread Information

Users Browsing this Thread

Similar Threads

Creating the data table for a chart.

Creating a pivot table and chart ..

Creating a chart, can't get a pivot table to work.

Creating table/chart from iteration loop ?

Creating a Table with if statements for a chart.

creating a pivot table and a chart

Creating a chart from a table of values

Bookmarks

Bookmarks

Posting Permissions