I am new to lookup value function, I have applied same in my sheet but error occurs. Please help to resolve.
Name: Maurya
Salary: Should be displayed as 30,000
City: Should be displayed as Ahmednagar
Formula Applied: =LOOKUP(E4,A2:C18,B2:B18) (Column Salary)
=LOOKUP(E4,A2:C18,C2:C18) (Column City)
From India, Delhi
23Name: Maurya
Salary: Should be displayed as 30,000
City: Should be displayed as Ahmednagar
Formula Applied: =LOOKUP(E4,A2:C18,B2:B18) (Column Salary)
=LOOKUP(E4,A2:C18,C2:C18) (Column City)
From India, Delhi
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
Error.JPG
ESIC ERROR.docx