Vlookup issue

[Tartesos]

Im using the Vlookup formula but there is a problem. If I use =VLOOKUP(B4,data!B4:$AH$2488,33,false) the information that is display is correct if I keep the orden on the AH column but if I ramdom the input on B5 and use any data from AH but not keeping the orden the output data is not correct.
Can I do something to make sure that the formula will always take the correct output data even if is not on the same place on the AH column??
Maybe another formula ???

Thanks

 

[John Davis]

Im using the Vlookup formula but there is a problem. If I use =VLOOKUP(B4,data!B4:$AH$2488,33,false) the information that is display is correct if I keep the orden on the AH column but if I ramdom the input on B5 and use any data from AH but not keeping the orden the output data is not correct.
Can I do something to make sure that the formula will always take the correct output data even if is not on the same place on the AH column??
Maybe another formula ???

Thanks

Does this help?

=VLOOKUP(B4,data!$B$4:$AH$2488,33,false)