Gingertrees
06-03-2009, 08:29 AM
Hello,
I've been having trouble with vlookup in practice. Several sheets use vlookup to populate client info from the "Cases" sheet. I initially had this indexed by a text field, but other posts informed me that was problematic so I tried a numeric index instead. The problem I encounter is antime that index number is changed or deleted, everything else goes haywire. Suddenly client #4's info appears when I select client #1 or client #2. Or sometimes client #3;s info changes to all #N/A when called up. (Order is random).
I have attached a version of my workbook for your convenience. Please let me know if you have any ideas on how to fix this, thank you ever so much!!!
--Ginger
I've been having trouble with vlookup in practice. Several sheets use vlookup to populate client info from the "Cases" sheet. I initially had this indexed by a text field, but other posts informed me that was problematic so I tried a numeric index instead. The problem I encounter is antime that index number is changed or deleted, everything else goes haywire. Suddenly client #4's info appears when I select client #1 or client #2. Or sometimes client #3;s info changes to all #N/A when called up. (Order is random).
I have attached a version of my workbook for your convenience. Please let me know if you have any ideas on how to fix this, thank you ever so much!!!
--Ginger