I need to add a figure from one worksheet chart to another worksheet in same workbook

**oakchas** · 06-11-2013, 11:38 AM

I need to add the value from an intersection of a 2 axis worksheet (chart?)
to the value on another worksheet in the same workbook...

Vlookup works fine for the first example (product a)in the included workbook,

But I don't know how to get the data from the third sheet for the data in the second example (product b).

test Book2.xlsx

**DBY** · 06-11-2013, 12:38 PM

Hello
Try the following:

Please Login or Register  to view this content.

However, this returns 2.45 not 2.40 as you state in your example.

Hope this helps.
DBY

**oakchas** · 06-11-2013, 02:11 PM

Originally Posted by DBY

Hello
Try the following:

Please Login or Register  to view this content.

However, this returns 2.45 not 2.40 as you state in your example.

Hope this helps.
DBY

See, that's why I use excel, to avoid human error... 2.45 indeed... Now, I'll try it and get back, thanks.

**oakchas** · 06-11-2013, 02:12 PM

Well, another one for the solved pile... thank you so much for the help!

**DBY** · 06-11-2013, 02:51 PM

Glad I could help. Just noticed I missed off the False statement at the end of the Vlookup.

So if you want an exact match then this needs to be set. The way your table is at the moment it doesn't matter but if your table is not sorted then you would need an exact match.

Please Login or Register  to view this content.

DBY

**oakchas** · 06-11-2013, 03:30 PM

Originally Posted by DBY

Glad I could help. Just noticed I missed off the False statement at the end of the Vlookup.

So if you want an exact match then this needs to be set. The way your table is at the moment it doesn't matter but if your table is not sorted then you would need an exact match.

Please Login or Register  to view this content.

DBY

Exact match not necessary... the thickness can vary by .1 but the chart only "allows" for .5. Temps are by whole degree...

But thanks so much for your help...

I need to add a figure from one worksheet chart to another worksheet in same workbook

LinkBack

Thread Tools

Rate This Thread

Display

I need to add a figure from one worksheet chart to another worksheet in same workbook

Re: I need to add a figure from one worksheet chart to another worksheet in same workbook

Re: I need to add a figure from one worksheet chart to another worksheet in same workbook

Re: I need to add a figure from one worksheet chart to another worksheet in same workbook

Re: I need to add a figure from one worksheet chart to another worksheet in same workbook

Re: I need to add a figure from one worksheet chart to another worksheet in same workbook

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions