Ok. So, for example, Enter a title "Part ID" in G1 and "Description" in H1, then in G2 enter a Part Number, and H2 enter a corresponding description. Repeat this in G3:H3, G4:H4 and so on until you've created a table of parts/descriptions.
Now, in A2 enter the part number: 019-2000, then go to B2 and re-invoke the Vlookup dialogue box you have in your picture. Click in the first field, then click cell A2.
Then click the next field (table_array), then select from G1 to H (and whatever the last cell you entered info into). Then hit the F4 key (this will add $ signs in the table reference to make it absolute -- meaning you can copy formula down the column for more matches, if desired).
In the next field enter a 2. This means retrieve results from 2nd column in the table.
In the last field enter the word False. This tells Excel to look for exact match only.
Finally, click Ok. You should see a result in B2.
If you enter a different part number in A2, you should get a different result in B2.
If you want to list parts in A2, A3, A4, etc, you can copy the B2 formula down to get the corresponding results.
Hope this helps. I will be leaving in a few minutes... so hope it works. Try looking at the video I attached again...
Note: If you want to move the table to another sheet, you can cut and paste it to another area and the formula will adjust itself accordingly.
|