Hello,
I need to make an excel that contains about 5 sheets. At an other sheet I have to enter the value of a cell from a different sheet but using vlookup, I also have to check if the value is not empty (anything >0). So I have to combine vlookup and IF functions.
How can I use vlookup to enter values to a different sheet? I tried but no luck. I dont know much about excel I am technician PC (cable management etc).
Can I find an example somewhere?
If needed I can upload the excel as example.
Thank you!
I need to make an excel that contains about 5 sheets. At an other sheet I have to enter the value of a cell from a different sheet but using vlookup, I also have to check if the value is not empty (anything >0). So I have to combine vlookup and IF functions.
How can I use vlookup to enter values to a different sheet? I tried but no luck. I dont know much about excel I am technician PC (cable management etc).
Can I find an example somewhere?
If needed I can upload the excel as example.
Thank you!