vlookup ????

L

locutus243

I hope I can explain this correctly, any help would be v.gratefull
recieved.

I have an excel worksheet with three columns of data in it. In
seperate cell I want to return a value from the third column by lookin
up against the first two columns.

ITEM NO OPTNDESC SIZE%
22E895 12/14 15.11
16/18 27.11
20/22 25.11
24/26 18
28/30 14.66
25S522 12/14 15
16/18 27
20/22 25
24/26 18
28/30 15

e.g. I want to return to return the size if the Item number is 25S52
and the OPTNDESC is 20/22. (and then have an automatic change if eithe
the Item Number or the OPTNDESCR is changed)

My first thought is a simple vlookup function, but in its original for
it doesnt have enough arguments to do this, perhaps it needs an AND o
IF function with it.

Thanx

Mar
 
G

Guest

Hi

From your post it's difficult to tell the layout of your data - but it looks
like you'll have difficulty with using a standard built-in function.
The item number is only entered once in its column, with the relevant sizes
in rows alongside, below. To make life a lot easier, you would need to fill
down the item number, so that every size had an item number alongside. You
could then use a formula like this:
=SUMPRODUCT(--(A2:A50="22E895)*--(B2:B50="16/18")*(C2:C50))
 
D

Domenic

Hi,

It looks like the format for your data is consistent. If that's th
case, then try the following:

=VLOOKUP(F2,OFFSET(A1,MATCH(E2,A2:A11,0),1,5,2),2,0)

where F2 contains the OPTNDESC of interst and E2 contains the Ite
Number of interest.

Hope this helps
 
A

aducutlas

Hi

I had the samr problem. I used CONCATENATE to combine cells then ne
column to VLOOKU
 
Top