# VLOOKUP problem with multiple occurrences of identical data

#### jtalbour

##### New Member
Question for you all

1. In sheet 1 I would like to enter a number in A:3 and pull data from sheet 2 to fill in B:3 - H:3

problems:
data in sheet 2 can have multiple occurrences of the identical data and I just want to pull the first occurrence of data found on sheet 2

Here is an example

sheet 1 (destination)
Book2
ABCDEFGH
1CODEITEMZONE1ZONE2ZONE3ZONE4ZONE5ZONE6
2
3737666PEAR25.1699379938.1299
4758148BLUEBERRY71.5299729900
5
6
7
8
9
10
11
12
Sheet1

### Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

##### Well-known Member
Hello,

try VLOOKUP, it will find the first match.

Replies
10
Views
499
Replies
4
Views
967
Replies
0
Views
464
Replies
5
Views
789
Replies
12
Views
988

1,171,204
Messages
5,874,342
Members
433,045
Latest member
Beleric3380

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back