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