Lookup Statement

**seanyc** · 06-21-2012, 07:26 AM

I am trying to build something that says for every time ="x" is in column g, to display a value "y" in the adjacent cell in column H. I tried doing a =IF formula however I have more than 7 different combinations and therefore cannot use that.

**san2525** · 06-21-2012, 07:32 AM

lookup( __, {-,-,-,-,-,-,},{-,-,-,-,-,-})

**seanyc** · 06-21-2012, 07:44 AM

how does that work exactly?

**san2525** · 06-21-2012, 07:45 AM

upload your sample sheet

**seanyc** · 06-21-2012, 07:48 AM

it is too large. I want to be able to say, in one cell, everytime any cell in G="X" input "Y" in the adjacent in column H, then everytime any cell in G="X2" input "Y2" in the adjancet in H, and so one for about 10 combinations.

**san2525** · 06-21-2012, 07:52 AM

lookup ( input cell , {d1,d2,d3,d4,d5,d6,d7},{r1,r2,r3,r4,r5,r6,r7})

input cell = link the cell where you enter x
d = domain r= range of your all 7 sets of combinations.. try it

else u hv to uplod your sample worbook

**seanyc** · 06-21-2012, 07:56 AM

Here is an example. I need the corresponding letters and values in A and B to be inputted for every time each one in A is dislayed in column G.

**NBVC** · 06-21-2012, 07:56 AM

Note, for the LOOKUP to work, you need to make sure that the first array, {d1,d2,d3,d4,d5,d6,d7} is in ascending order.... and the second range must be correspondent to the values in the first range.