First time here? Check out the FAQ!
x

Lookup from Multiple Tabs.

0 votes
asked by about Microsoft Office Excel
edited by

Does Excel have a formula I can use on my master page to look up a sheet name in another cell on the same page and then perform the usual look up, match & index etc on that 'looked-up sheet', all within the same workbook?

1 Answer

0 votes
answered by (264k points)
edited by

There is a formula called VLOOKUP. It should suit your purpose. You can access the official Microsoft website to read more about it. Since the process involves using various arguments, the best variant is to read and understand carefully in order to work with it.

Microsoft Office page: https://support.office.com/en-in/article/VLOOKUP-function-adceda66-30de-4f26-923b-7257939faa65

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register
...