vlookup insert

[john.e.palmer]

In win Excel, when creating a vlookup formula, I could hit F3 and a
list of defined names would appear so that I could select the right
one for the table_array. What's the equivalent in Mac Excel?

Thanks.

 

[CyberTaz]

Hello John -

The command doesn't have a kybd shortcut assigned to it but you can do
either of at least 2 things:

1- On the Mac you can use Insert> Name> Paste from the Excel menu bar to
bring up the list of range names, or

2- Go to the Customize Keyboard dialog box, locate the Paste... Command (in
the Insert category) and assign a keystrok of your choice.

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[john.e.palmer]

Hello John -

The command doesn't have a kybd shortcut assigned to it but you can do
either of at least 2 things:

1- On the Mac you can use Insert> Name> Paste from the Excel menu bar to
bring up the list of range names, or

2- Go to the Customize Keyboard dialog box, locate the Paste... Command (in
the Insert category) and assign a keystrok of your choice.

HTH |:>)
Bob Jones
[MVP] Office:Mac

Thanks for the help...