Loacate a range of cells

D

Donald Johnson

Excel is Company Forms, that have book numbers in seveval
range of cells. VB6 we enter the book number which has a
var. and a quanity var. So I want to find the book Number
in range B30:B65 and put the quanity in range A30:A65.
This will be on Sheet1.
Any help would be appreciated.
Thanks
Don
 
D

Dave Peterson

Maybe =vlookup() against a table that contains the book number in column A and
quantity in column B (probably on a different sheet???)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
GENERATE RANGES FROM GIVEN NUMBERS(START/END) AND COMPILE INTO ASINGLE LIST. 7
Formula Help 2
Macro to copy data X number of times into a column 0
If adjancent cell contains text then ignore, otherwise copy and pastemultiple values in one column t 1
Copy unformatted value of cell via macro 0
The real Horizontal Formula question 4
Cell values to an array, then array transpose to another workbook 8

Top