4pinoyjunior,

False = 0, and forces an exact match rather than finding the value before the first value that
exceeds the "looked up" number (using a 1) or the converse (using a -1) in a sorted table.

HTH,
Bernie
MS Excel MVP


"been drilbled to 2007" wrote in message
...
thanks Sir Bernie,

i've seen the help file about the match_types 1,0,-1

what does this False mean
=INDEX(I1:P1,MATCH(A1,U1:AB1,FALSE))<<<<<

thanks for any enlightenment
4pinoyjunior
--
*****
birds of the same feather flock together..



"Bernie Deitrick" wrote:

Driller,

Something like

=INDEX(I1:P1,MATCH(A1,U1:AB1,FALSE))

HTH,
Bernie
MS Excel MVP


"been drilbled to 2007" wrote in message
...
is it possible to make a lookup_reference and lookup result directly from a
non-adjacent cells,,

maybe something like this...

=LOOKUP(A1,{U1:V1&","&X1:Y1&","&AA1:AB1},{I1:J1&", "&L1:M1&","&O1:P1})

like if the value on A1
is exactly equal to a value on either U1 or V1, then RESULT will be from L1
or M1, and if not found, it will search again on the next...

if not possible, please advice

thanks and more power
driller