Posted on 2003-03-13
I am having a problem using VLOOKUP. I have the lookup based on the value in the adjacent cell which is a validation box. If the box has a value then the VLOOKUP checks for the matching value based on the two column that are linked to another spreadsheet. The value in the other spreadsheet are sorted so the 1st column is in alphabetical order which VLOOKUP needs to give back a correctly found match. The problem is if the VLOOKUP is > than any field that is not populated beyond row 45, the VLOOKUP does not see the new value. I wanted the VLOOKUP to check the entire column so no matter if a new record was added to the second spreadsheet it would show up in the validation box (which it does) and then the VLOOKUP would find the match (which it does), but only through row 45, unless you keep changing the row number in the formula any time you add a row on the main spreadsheet. This is the VLOOKUP formula '=IF($K2 <> "", VLOOKUP($K2,$IA$2:$IB$58,2,TRUE), ""), this is the way it should look '=IF($K2 <> "", VLOOKUP($K2,$IA$2:$IB$7000,2,TRUE), "").
Does anyone know why it does this? Thanks for your help in advance. JaiTrai