Getting values based on similiar IDs in two different books

[Ishabida]

Hello all, my first time here

I have 2 books, both of them contain 4k rows of information. In each book there is a column called unit_id, the amount of IDs are not the same in both books. In one of the books I have min_stock column, indicating what the minimum stock for a given item(unit_id) should be. In the other book I have the same setup but with no numbers indicating the value of min_stock.

What I want to do is to do a search based on the IDs(compare them) and get the min_stock value inserted if the function find a match.

I tried with the VLOOKUP function but all I manged was to get it to compare the IDs and insert #N/A or the ID if it was a match.

Hope someone can help me out.

Thanx in advance

Ishabida

 

[konew1]

Hi
It sounds to me like you have wrong value in the index_number parameter, or the Min-stock data is in a column prior to the stock code.

 

[konew1]

Hi
It sounds to me like you have wrong value in the index_number parameter, or the Min-stock data is in a column prior to the stock code.