Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Vlookup
Resolved · Low Priority · Version Standard
Deirdre has attended:
Excel Advanced course
Apart from numbering columns incrementally in a specific row or counting the columns, is there any way to determine the column number when using vlookup?
No - you will need to know the number of the column you want. You can get a list by highlighting the entire headings row and in a new tab right click in a cell. Choose Paste special and select transpose. This will give you a vertical list which might help you see what columns there are in a list format which you can then add numbers to.
|
Excel tip:Deleting cells, Rows & columnsplace your cursor on a cell, row number or column letter and use CTRL + -. |
We'll call during UK business hours
Server loaded in 0.09 secs.