Need help with Vlookup

I need to fill in Manufacturer and Model on sheet 'Manufacturer Missing' number using Tag number match on sheet Elec Equip List.
Test-Vlookup-Items.xlsx
ssblueAsked:
Who is Participating?
 
ShumsConnect With a Mentor Distinguished Expert - 2017Commented:
Hi Sue,

Please find attached...unfortunately, there are no Manufacturer details available for current Tag Number Listing.
ssblue_Test-Vlookup-Items.xlsx
0
 
NorieConnect With a Mentor VBA ExpertCommented:
For manufacturer:

=VLOOKUP(B2,'Elec Equip List'!$A$1:$C$336,2,0)

For model:

=VLOOKUP(B2,'Elec Equip List'!$A$1:$C$336,3,0)
0
 
ssblueAuthor Commented:
Thanks for the help.
1
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.