Needing to Return a Range of Values

  • Thread starter Thread starter Jayhawktc
  • Start date Start date
J

Jayhawktc

Is there a way to return a range of values, similar to the way a Vlookup
returns one value from a column.

Example: On a worksheet you have a form to enter a customer number and
using that entered customer number you would return a range of values
in different columns such as that customers purchased products, price,
quantity etc...

Any help would be greatly appreciated.
 
Hi J...

Assume column A has the customer number and the customer data is in B, C, D
& E.

Select cells G1 through J1 and in the highlighted cell, G1, enter this.

=VLOOKUP(F1,A1:E50,{2,3,4,5},0)

Now do a array enter- Ctrl + Shift + Enter
Enter your customer number in F1.

HTH
Regards,
Howard
 
You must log in or register to reply here.

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

Supressing a #VALUE! error returned? 3
Convert code to lookup three criteria return fourth 15
Creating a UDF to search a cell's formula 8
List box value returns the row number of the list box range row 5
Column number of last column that returns value ignore formulas 8
Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7
.Find and return range 5
Look up range and return value 5

Back
Top