pull information from another sheet when input information

[hquintana84]

Im trying to pull information from another sheet when i enter data. for example

A B C D E F
1 LMPASC01100CC 83 110 12 12 877407005637
2 LMPASC07100CC 76 110 12 12 877407005668
3 LMPASC0789CC 72 100 12 12 877407005651
4 LMPASC0789QC 72 100 12 12 874407005643


I INPUT

NEW SHEET
A B
1 877407005668 NEED TO PULL A2

SO I NEED TO MATCH A1 WITH F1:F4 AND PULL CORRESPONDING PART NUMBER IN A

[José Augusto]

Hi

Use

Please Login or Register  to view this content.

[BadlySpelledBuoy]

Please Login or Register  to view this content.

BSB

[hquintana84]

How can i keep the cell blank instead of showing #n/a
=index('master part number'!a3:a1327,match(a3,'master part number'!f3:f1327,))

[José Augusto]

Hi

You can use

Please Login or Register  to view this content.

Regards