| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup using 2 cells as the "X" and "Y" coordinates....
I am trying to make a formula that will look at two cells (K2 and L2) which
can have the following typed in them: K2 can be "A, B, C, D, or E" L2 can be "I, II, III, or IV" I have an array with A-E on (J1:N1 of Sheet2) and I-IV on (I2:I5 of Sheet2) Based of of what is typed in the cells I want to look it up in the array. Please help. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Lookup using 2 cells as the "X" and "Y" coordinates....
=INDEX(Sheet2!J2:N5,MATCH(L2,Sheet2!I2:I5),MATCH(K 2,Sheet2!J1:N1))
-- David Biddulph "kcsims" wrote in message ... I am trying to make a formula that will look at two cells (K2 and L2) which can have the following typed in them: K2 can be "A, B, C, D, or E" L2 can be "I, II, III, or IV" I have an array with A-E on (J1:N1 of Sheet2) and I-IV on (I2:I5 of Sheet2) Based of of what is typed in the cells I want to look it up in the array. Please help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can "y" be determined for a given "x" on a smoothed x-y plot | Charts and Charting in Excel | |||
| Count cells that contain "Y" in columnA IF contains"X" in columnB | Excel Worksheet Functions | |||
| cells formatted to tick when text value "Y" if or null if "N" | Excel Discussion (Misc queries) | |||
| if one cell has "X" textin contents, then pull cell "Y"... | Excel Worksheet Functions | |||
Hybrid Mode
