adjacent cell return value? trying to fetch data from another worksheet

**L.Storm** · 09-23-2019, 05:33 PM

Hi gang
Thanks in advance for the assistance.

I'm working with two separate excel files in different departments.

Book1 "my" file I work on
Book2 "Master list" of values I search on.
Book2 has Column A showing values of AZ###
and Column B has numbers ###-#### associated with each AZ### value

I'm trying to find a way to look for an adjacent cell value on searching for a particular AZ### value in Book2
and return that value in Book1 next to the value I'm looking for

excel search.jpg

I hope I explained this well enough and the image helps

Cheers

**jeffreybrown** · 09-23-2019, 05:58 PM

Give this a try.

=INDEX([Book2]Sheet1!$B$1:$B$11,MATCH(A1,[Book2]Sheet1!$A$1:$A$11,0))

Note: For future references, a sample workbook is much easier to work with than a picture. A picture we must recreate.

**L.Storm** · 09-23-2019, 06:03 PM

Thanks Jeffrey, nice one.

I was playing around and came across
=VLOOKUP(A1,[Book2]Sheet1!$A$1:$B$10,2,FALSE)

Both formulas work great.

Cheers for the assistance and quick reply +rep

**jeffreybrown** · 09-23-2019, 06:05 PM

You are very welcome and thanks for the feedback. You're right, often times more than one way to skin the cat.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

**L.Storm** · 09-25-2019, 08:07 AM

Just realising, if by chance, someone moves the book2 worksheet. is there a way the above formula can be saved, data wise. as I don't want book1 to change the results.

adjacent cell return value? trying to fetch data from another worksheet

LinkBack

Thread Tools

Rate This Thread

Display

adjacent cell return value? trying to fetch data from another worksheet

Re: adjacent cell return value? trying to fetch data from another worksheet

Re: adjacent cell return value? trying to fetch data from another worksheet

Re: adjacent cell return value? trying to fetch data from another worksheet

Re: adjacent cell return value? trying to fetch data from another worksheet

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Trying to compare one cell with a list of cells and return data in adjacent cell on match

FORMULA: Find SKU and return data from adjacent cell

Vlookup formula on duplicates, then find max value in adjacent cell, return adjacent cell

Find text (multiple) in worksheet and return sum of values in adjacent cell.

[SOLVED] Fetch Data: Return Multiple Rows based on Cell Content

Formula needed to fetch data from different worksheets and include adjacent cells

Bookmarks

Bookmarks

Posting Permissions