Forum Discussion
Excel data transfer
Good morning,
I have a question about this thing in excel. From the following list i have some "codes" and the working time for those "codes". For the code number 38 i have the working time 1minute
In the following file there is a posiblity to transfer the value when i write manually the code there?
Typing 38 and in the third sector to be automaticaly write the value 1 from the table?
I hope i explain good. My english is not the best 🙂 I appriciate
4 Replies
VlookUp() will also do.
=VLOOKUP(D12,'TEMPI MACCHINA'!$A$3:$B$27,2,0)If you are using European settings, change those commas to semi-colon.
- Many thanks! It worked!
- Hi, if you have the latest version of Excel Xlookup function should solve this. Or use Index/Match if you have an older version.
/GeirHogstad_Raadgivning Thank you! it worked!
