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
Find answers from people who have previously dealt with business and work issues similar to yours - Please Register and Log In to CiteHR and post your query.
Error.JPG
ESIC ERROR.docx