Vlookup

Can you please explain this vlookup formula in column AN?
screenshot.pngscreenshot2.pngscreenshot3.pngscreenshot4.png
mustish1Asked:
Who is Participating?
 
Subodh Tiwari (Neeraj)Connect With a Mentor Excel & VBA ExpertCommented:
As per the VLookup formula...

Lookup Value --> C2
Lookup Table --> $A$2:$B$24 on Department Conversion Sheet.
Column Index --> 2  i.e. 2nd column in the lookup table.
False --> Exact Match.

So the formula checks the lookup value (C2) in column A in the range A2:B24 on Department Conversion Sheet and if it finds the exact matching value, it returns the corresponding value from column B.
1
 
Vijaya KumarConnect With a Mentor Commented:
AS per your look up and data

c11=> department_id (example=>228)
$A$2:$B$34=> the other sheet value
lookup.PNG
2=> Department in ($A$2:$B$34)

False => exact match( either u should specify 0 or 1)

so it takes store id and compare with department conversation sheet A column store id when it matches return department name
1
 
mustish1Author Commented:
Thank You.
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
You're welcome!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.