Find data in another spreadsheet

[Closed]
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,

I need my stock checker to pick up data from our suppliers spreadsheet which they change daily.

So what i need for example is:

To match the stock - Find item code eg the text AA001 in column A of suppliers spreadsheet, lets just say that is on row 5

To bring in the data to our spreadsheet- From the same row that AA001 appears in use data that appears in column C, so find AA001 then our column d=row 5 column c

THEIR SPREADSHEET

A B C
ROW 5 AA001 | APPLE | IN STOCK |

OUR SPREADSHEET

A B C D
ROW 1O AAOO1 | APPLE | PRICE | STATUS


The suppliers add and remove items to their spreadsheet so we need ours to search and find the data as opposed to exactly matching to a permanent cell.


Hope this makes sense!
Is this possible and how would the formula read?

Many thanks!




1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
i wonder whether I have understood you and I am confuse by the example

see the trivial file which you can download from

http://speedy.sh/fdrqt/ja.xls

see the formula in sheet 2 cell D9 which is

=VLOOKUP(A9,Sheet1!$A$1:$D$12,3,0)