2 values to lookup

 

 

Excel 2016

I have some data which requires a 2 value lookup and i cannot work out which formula to use:

 

Example

line item=1 column item =1    value should be SMITH

line item=1 column item =2    value should be ABC DESIGN

 

both these have different values in the data set. i expect to see 2 different values in the relevant boxes in the table presented.

the data is presented as:

COLUMN ITEM LINE ITEM As Of Date GROUP CODE ISSUER ID ENTITY VARCHAR VALUE
1 1 31-Dec-2016 Group AXIOM AXIOM A1235 Smith
2 1 31-Dec-2016 Group AXIOM AXIOM

A1235

ABC Design

By: Rashmi

Leave a Reply

Your email address will not be published. Required fields are marked *