Lyconal
06-07-2008, 02:08 AM
Hi Guys, I hope you can help me please : pray2:
I have an excel spreadsheet that updates daily (Pre-Recorded Macro), but I want to be able to do another task on the data.
I have data populating cells C13 - C150, and I want it to display certain text in Cells A and B depending on the value in the C cell.
So if C13 cell had 'Test' in it, I would want Cell A13 to say 'This is a test' and cell B13 to say 'Please Enter a Value'.
I have it written in SELECT CASE, but it is 703kb long and will not run as it is far too large. It is so large because each C cell has a different value in it, and depending on that value, it must say something different in cells A and B.
Thanks for any help
..:: EDIT ::..
Title Changed to VLOOKUP HELP
I have an excel spreadsheet that updates daily (Pre-Recorded Macro), but I want to be able to do another task on the data.
I have data populating cells C13 - C150, and I want it to display certain text in Cells A and B depending on the value in the C cell.
So if C13 cell had 'Test' in it, I would want Cell A13 to say 'This is a test' and cell B13 to say 'Please Enter a Value'.
I have it written in SELECT CASE, but it is 703kb long and will not run as it is far too large. It is so large because each C cell has a different value in it, and depending on that value, it must say something different in cells A and B.
Thanks for any help
..:: EDIT ::..
Title Changed to VLOOKUP HELP