IF Function or Lookup or ???

  • Thread starter Thread starter Rich
  • Start date Start date
R

Rich

Hello

I wonder if anyone can help with the following.

I have two excel worksheets, one shows book numbers and
the appropriate week numbers for each book, as example
below. (The original has thousands)

Book Week
1305 4
1350 3
1353 10
1387 11
1401 6

We receive a report from an external source (second
spreadsheet) with a list of our book numbers but without
the Week numbers. (Thousands again).
Is there any way of writing a function or VB so that all
we need to do is click a button or whatever so that the
second spreadsheet is updated with the correct Week number
for each of the books? (Note - Different Books could have
the same Week number etc)

Thanks
 
Use "VLOOKUP" function.

In the first worksheet, arrange/sort the data in ascending
order which has got both the Book and Week. Highlight the
complete data to name it as a "Range"
In the second worksheet, once again sort the data column
containing the "Book" values. Use the simple Vlookup
function.

If you need assistance, send sample worksheet and can give
the formula back

Rgds,
Murali
 
Back
Top