Lookup and return data after using ref table

**richardj** · 09-11-2009, 07:24 AM

Hi All,

I have a set of raw data that I need to return in a certain way to assist analysis. It is prices of products with similar names that I need to put on one line if this is possible

It is pretty complicated so I have attached an example sheet!

In the data table I have 8 lines of products with prices, they are infact just 2 products but called slightly different by suppliers. (I am Supplier A)

In the lookup table I have manually put all similar products together in one line (It would be inmpossible to do automatically as product names can be totally different)

What I want to do is return the prices of all suppliers as per what Supplier A calls the product as in the desired results table

Is this possible??

Any help would be greatly appreciated

**DonkeyOte** · 09-11-2009, 07:58 AM

Based on your sample file layout:

C15:
=VLOOKUP(INDEX($G5:$J5,COLUMNS($C15:C15)),$B$3:$D$10,3,0)
copied across matrix

(note you have typo re: Name 4 in your Raw Table)

**richardj** · 09-11-2009, 08:38 AM

Thats Fantastic, thanks Donkeyote.

Is there also a way of pulling back the name in columns E3:E10 using the lookup table?

Thanks

**DonkeyOte** · 09-11-2009, 09:25 AM

I guess something like:

Please Login or Register  to view this content.

In reality you're generally better off storing data along the lines of:

Please Login or Register  to view this content.

Things become more easier than - ie basic VLOOKUP would suffice.

Lookup and return data after using ref table

LinkBack

Thread Tools

Rate This Thread

Display

Lookup and return data after using ref table

Re: Lookup and return data after using ref table

Re: Lookup and return data after using ref table

Re: Lookup and return data after using ref table

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions