data changes vlookup

[alan myers]

I have a workbook with data in the data tab
I have an input tab with vlookups on it
win I change the data in the data tab my vlookups come up with a #ref error
any help would be nice

here is my workbook

https://www.mediafire.com/file/n9mh5jz2a9qkj18/sherry_sat_put_out_version-21a.xlsm/file

 

[bstory84]

Your worksheet does not appear to have any VLOOKUP Errors. There are alot of #REF errors because the cells that the formulas (input+input+etc...) were referencing have been deleted.

You input and data tabs look clean. the worksheets named combine, carriers, sheet3 need attention.
Also, I would hide worksheet named carriers if I were you. Shouldn't post with that data.

 

[alan myers]

Your worksheet does not appear to have any VLOOKUP Errors. There are alot of #REF errors because the cells that the formulas (input+input+etc...) were referencing have been deleted.

You input and data tabs look clean. the worksheets named combine, carriers, sheet3 need attention.
Also, I would hide worksheet named carriers if I were you. Shouldn't post with that data.

but why does it do that win I put new data in the same cell it comes up with the red error

 

[bstory84]

I'm sorry but you will need to be more specific.
what do you mean by "NEW" data?
Additional rows?
are you changing values in the same rows or changing the row completely?
What values are you entering and what cells are you entering them into on which worksheets.

Currently all VlOOKUPS on this workbook have no errors.

 

[alan myers]

I'm sorry but you will need to be more specific.
what do you mean by "NEW" data?
Additional rows?
are you changing values in the same rows or changing the row completely?
What values are you entering and what cells are you entering them into on which worksheets.

Currently all VlOOKUPS on this workbook have no errors.

i replace all data on the data tab with new data but in the cells that have data

 

[alan myers]

I know the vlookup works but when I change the data then I get the ref errors

 

[bstory84]

Are the values in Column A changing?
If so the Values in Column A on the input & Column A on the data tab are used as the lookup value. If the value does not exist in the data tab then the formula in the input tab will error.

If this is not the case then How are you Changing/adding the new data?
Are you deleting the old data (rows /cells)?
Or are you copy and pasting over the top of them?

 

[alan myers]

Are the values in Column A changing?
If so the Values in Column A on the input & Column A on the data tab are used as the lookup value. If the value does not exist in the data tab then the formula in the input tab will error.

If this is not the case then How are you Changing/adding the new data?
Are you deleting the old data (rows /cells)?
Or are you copy and pasting over the top of them?

I clear the data in the data tab then paste in the new data

 

[alan myers]

Are the values in Column A changing?
If so the Values in Column A on the input & Column A on the data tab are used as the lookup value. If the value does not exist in the data tab then the formula in the input tab will error.

If this is not the case then How are you Changing/adding the new data?
Are you deleting the old data (rows /cells)?
Or are you copy and pasting over the top of them?

copying and pasting over but column a data is always the same

 

[alan myers]

Are the values in Column A changing?
If so the Values in Column A on the input & Column A on the data tab are used as the lookup value. If the value does not exist in the data tab then the formula in the input tab will error.

If this is not the case then How are you Changing/adding the new data?
Are you deleting the old data (rows /cells)?
Or are you copy and pasting over the top of them?

thanks for your time I got a workaround