Extract data

[mohan08]

Hi

Need help on extraction adjacent value of matching lookup value.
In attached spreadsheet table A1:H13 contains data and not properly formatted has details
On the same spread sheet I need to extract details for column m1 to m8 with value of next cell value from the table A1:H13

 

[Logit]

.
Assuming the locations (cells) of each data will never change ...

N1 "=B1"

N2 "=B2"

N3 "=B3"

N4 "=E1"

etc

etc

 

[mohan08]

Hi Logit,

it will be changing since it will be filled by different users and different department. what remains unique in all the files is m1 to m8

 

[Logit]

You are saying the data will not always be located in B1, B2, B3, E1, etc. etc ?

If that is the case, it would be best to change the layout of your worksheets so the data is always located in the same place.

 

[vletm]

mohan08
Many things could do smoother, but many time few rules would make things clearer.
Press [ Extraction ] -button.
Note: Those keyword should be as You've given in Your .. sample.

 

[mohan08]

Hi Vletm, Thanks for your help