Re: Lookup data
- From: Domenic <domenic22@xxxxxxxxxxxx>
- Date: Mon, 02 May 2005 11:54:56 -0400
Do Columns B, D, and F contain numerical values? If so, try...
=SUMIF(A1:E100,G1,B1:F100)
OR
=SUMIF(A:E,G1,B:F)
....where G1 contains your lookup value. Adjust the ranges accordingly.
Hope this helps!
In article <#uVRDMxTFHA.2172@xxxxxxxxxxxxxxxxxxxx>,
"Tosca" <no-spam@xxxxxxxxxxxxx> wrote:
> Hello everyone
>
> I have Excel 2003 and a grid of data. Columns A, C and E contain unique
> data (one instance of each data value in each column and within the whole
> grid) and the data in each of the columns is sorted alpha-numerically (A & B
> relate to each other as do C & D and E & F). I need to be able to lookup a
> particular value in the whole grid and return the contents of the cell
> immediately to the right of the cell that matches the data. The match will
> be exact. I had thought about using VLOOKUP but that can't be used to refer
> to the whole grid of data (so far as I'm aware) - it would have to refer to
> data contained in columns A & B or C & D or E & F. The data that is being
> sought may be in any of these columns and this is out of my control.
>
> I'm sure that this is simple - but it's beyond me! How can I perform this
> lookup?
>
> Thanks in anticipation.
.
- References:
- Lookup data
- From: Tosca
- Lookup data
- Prev by Date: RE: How do I add the sum of a series numbers generated by Rnd gen?
- Next by Date: Re: need a formula
- Previous by thread: Re: Lookup data
- Next by thread: Re: Lookup data
- Index(es):
Relevant Pages
|
