given :

range A range B range C

range 44 1 b xa

range 45 2 b xb

range 46 3 c xc

range 47 4 d xd

range 48 5 e xe



i am using the vlookup function : =vlookup(d44:d48,$A44$:$A48$,$b44$:$b48$)

when i write 4 i get d
when i write 5 i get e

BUT WHEN I WRITE 6 I ALSO GET E !!! ect.... what should i do in
order to keep E only for 5 ???? is a fomula for that ???

The Vlookup formula you posted doesn't make sense and doesn't work, at least
in my version of Excel 2003. Try the following formula:

=VLOOKUP(D44,$A44:$B48,2,FALSE)

and copy down through row 48 if desired. The last argument, FALSE, tells
Vlookup to only return values for exact matches. Otherwise, the the next
largest value that is less than the lookup value is returned. With the FALSE
argument added, a lookup value of 6 will return #N/A because 6 was not found.
To return something else (in this example, "") istead of #N/A, use a formula
like this:

=IF(ISERROR(VLOOKUP(D44,$A44:$B48,2,FALSE)),"",VLO OKUP(D44,$A44:$B48,2,FALSE))

Hope this helps,

Hutch

"pierre" wrote:

given :

range A range B range C

range 44 1 b xa

range 45 2 b xb

range 46 3 c xc

range 47 4 d xd

range 48 5 e xe



i am using the vlookup function : =vlookup(d44:d48,$A44$:$A48$,$b44$:$b48$)

when i write 4 i get d
when i write 5 i get e

BUT WHEN I WRITE 6 I ALSO GET E !!! ect.... what should i do in
order to keep E only for 5 ???? is a fomula for that ???

IT WORKED THANK YOU !!!!
IF WE WOULD WANT TO USE THE ( LOOKUP) OR ( HLOOKUP) ...HOW TO USE IT
HERE IN MY ISSUE ?????

PLEASE HELP ME ON THIS ONE .......THANKS IN ADVANCE



=VLOOKUP(D44,$A44:$B48,2,FALSE)

and copy down through row 48 if desired. The last argument, FALSE, tells
Vlookup to only return values for exact matches. Otherwise, the the next
largest value that is less than the lookup value is returned. With the FALSE
argument added, a lookup value of 6 will return #N/A because 6 was not found.
To return something else (in this example, "") istead of #N/A, use a formula
like this:

=IF(ISERROR(VLOOKUP(D44,$A44:$B48,2,FALSE)),"",VLO OKUP(D44,$A44:$B48,2,FALSE))


given :

range A range B range C

range 44 1 b xa

range 45 2 b xb

range 46 3 c xc

range 47 4 d xd

range 48 5 e xe