Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 ??? |