IF statements / VLOOKUP

%3CLINGO-SUB%20id%3D%22lingo-sub-3125757%22%20slang%3D%22en-US%22%3EIF%20statements%20%2F%20VLOOKUP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3125757%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI'm%20working%20on%20a%20large%20spreadsheet%20and%20hoping%20to%20do%20the%20following%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUsing%20an%20employee%20reference%2C%20i%20would%20like%20to%20generate%20a%20number%20in%20to%20a%20certain%20cell.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%20(in%20attached%20spreadsheet)%3A%3C%2FP%3E%3CP%3EIf%20employee%20number%201%20is%20on%20that%20sheet%2C%20id%20like%20value%202%20to%20equal%2010.%3C%2FP%3E%3CP%3EIf%20employee%20number%205%20is%20on%20that%20sheet%2C%20id%20like%20value%202%20to%20equal%2020.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3125757%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3127230%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20statements%20%2F%20VLOOKUP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3127230%22%20slang%3D%22en-US%22%3EThe%20attachment%20is%20missing.%3C%2FLINGO-BODY%3E
New Contributor

Hi,

I'm working on a large spreadsheet and hoping to do the following;

 

Using an employee reference, i would like to generate a number in to a certain cell.

 

For example (please see below):

If employee number 1 is on that sheet, id like value 2 to equal 10.

If employee number 5 is on that sheet, id like value 2 to equal 20.

 

Emp RefEmp NameValue 1Value 2
1Smith, A  
2Smith, B  
3Smith, C  
4Smith, D  
5Smith, E  
6Smith, F  
7Smith, G  
8Smith, H  
9Smith, I  
10Smith, J  

 

2 Replies
The attachment is missing.
Hi Juliano,

Thank you for your prompt response.

I missed out the most important part there!

Ive edited the first post as i cannot see how to attach a document.

Thanks in advance