using VLOOKUP for series data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Automate - 09 Mar 2008 05:14 GMT

I try to look for solution to automate using VLOOKUP to match the "part
number" and copy series data from another spreadsheet to working spreadsheet.
I have try the VLOOKUP and MATCH but only single value allow to copy.
Pls adv......chew

Reply to this Message

T. Valko - 09 Mar 2008 05:46 GMT

Need a more detailed explanation. Sounds like you want to return more than
one value. Post the formula you're using.

Signature

Biff
Microsoft Excel MVP

>I try to look for solution to automate using VLOOKUP to match the "part
> number" and copy series data from another spreadsheet to working
> spreadsheet.
> I have try the VLOOKUP and MATCH but only single value allow to copy.
> Pls adv......chew

Reply to this Message

L. Howard Kittle - 10 Mar 2008 21:26 GMT

Try this. If you are going to return 5 columns, select five cells in a row
and while selected enter this formula. The formula will only be in the left
most cell to start with.

=VLOOKUP(A1,B1:K15,{2,4,6,8,10},0)

Now hit Ctrl + Shift + Enter.

Looks up the value in A1 and returns five column (of your choice) in the
cells selected. If you modify the formula you must select all cells that
have the formula and make the changes and Array Enter again.
(Ctrl+Shift+Enter)

HTH
Regards,
Howard

Reply to this Message

Automate - 16 Mar 2008 05:45 GMT

hi

Need your adv whether this formula make sense to pull series of date from
Test2 worksheet to Test1 worksheet

=VLOOKUP("'Test 2'!A2:F9=403277-301", 'Test 2'!A2:F9, col_('Test
1'!L6:P6))

The formula keep on prompt me #NAME even how i adjust the mention formula

.......chew

> I try to look for solution to automate using VLOOKUP to match the "part
> number" and copy series data from another spreadsheet to working spreadsheet.
> I have try the VLOOKUP and MATCH but only single value allow to copy.
> Pls adv......chew

Reply to this Message