nuts. is the vlookup a better solution than using an index/match formula?
--
steph


"CLR" wrote:

Not a single formula.......each column reqires it's own........

In B1 put =VLOOKUP(A1,G1:J10,2,FALSE)
In C1 put =VLOOKUP(A1,G1:J10,3,FALSE)
In D1 put =VLOOKUP(A1,G1:J10,4,FALSE)
...etc etc

If necessary, you can also use ABSOLUTE cell references where needed and
copy and paste and/or insert the formulas by macro, if it's something you
have to do frequently.....all the details would be specific to each
application

Vaya con Dios,
Chuck, CABGx3



"steph" wrote:

ok. can you write a vlookup that pulls data from an entire row (21 columns)?
--
steph


"CLR" wrote:

The VLOOKUP function does not require that the Lookup Table be in numerical
order if one uses the FALSE option at the end of the formula......such as

=VLOOKUP(A1,G1:H10,2,FALSE)

Vaya con Dios,
Chuck, CABGx3



"steph" wrote:

hi--i'm trying to come up with either a function or a macro, & would
appreciate any input!

i have 2 worksheets, one with a list of production outputs for 12 production
machines. the 2nd worksheet is the crew that ran the lines. in the outputs,
each line has different values for each product code. (code, description, and
then specs.)

i'd like to set it up so that on the crew worksheet, a dropdown list will
provide the product code in the leftmost column. (that part i've got figured
out).

once the product code is selected, i'd like excel to lookup the row of data
related to that product code in the "outputs", and copy the entire row to the
"crew" worksheet. there are 21 columns to be copies, not including the 1st
column with the product code. i can't use a vlookup because the product codes
in the outputs sheet are not in numerical order (and can't be rearranged,
because there are several macros linked to other worksheets); i tried an
index/match formula but it only returns one cell value at a time. there are
also occasionally blank lines within each section's product codes.

any function/macro suggestions would be very welcome!
thanks
steph
--
steph