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
...
|