Thread: Worksheet search display problem

Hi,

After spending the best part of 2 hours trying to solve this with excel online help i have given up and require expert advice

I have two worksheets in the same spreadsheet.

The first is a master catalog which has three columns:

Part No
Description
Bin

The next worksheet displays a large selection of items out of the master catalog but only displays the following:

Part No
Description

My problems is that i can't figure out how to include the Bin location information from the master catalog for every entry on the other worksheet.

I.E. If Part Number = Part Number in master catalog then display bin number of that row.

This is probably an easy fix but it's a bit beyond my capabilites i'm ashamed to admit. Conditional formatting is about my limit lol

Thanks in advance

Avdo

With
On the Master sheet
Col_A contains Part No
Col_B contains Description
Col_C contains Bin
(Row_1 contains headings)

and
on the second sheet
Col_A contains Part No (already listed)
Col_B contains Description (already listed)
Col_C contains Bin (these need to be filled in)
(Row_1 contains headings)

This formula returns the BIN value associated with the Col_A Part No:

C2: =VLOOKUP(A2,Master!$A$2:$C$100,3,0)

Copy that formula down as far as you need.

Is that something you can work with?