View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Look up field and auto fill the rest

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


wrote in message
...
Thanks Biff! Worked great!

On Apr 1, 10:45 pm, "T. Valko" wrote:
Try this...

Assume your data on Sheet3 is in the range A2:D50

A2 on the Input sheet holds the drop down

Enter this formula in B2:

=VLOOKUP($A2,Sheet3!$A$2:$D$50,COLUMNS($A2:B2),0)

Copy across to D2

--
Biff
Microsoft Excel MVP

wrote in message

...