ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   What is the best way to lookup from another worksheet? (https://www.excelbanter.com/excel-worksheet-functions/445465-what-best-way-lookup-another-worksheet.html)

RyanCrc

What is the best way to lookup from another worksheet?
 
Hello,

I have created several Worksheets within a Workbook. One of which has a column with checkboxes (ACD Queue A). While in another worksheet (ACD Group Info) I want to reference the Checkbox and return another value (Employee Extension)from the same row. I am not sure of the best way to set this up. Lookup(IF, Marco....

Thank you for any support!!

Spencer101

Quote:

Originally Posted by RyanCrc (Post 1599750)
Hello,

I have created several Worksheets within a Workbook. One of which has a column with checkboxes (ACD Queue A). While in another worksheet (ACD Group Info) I want to reference the Checkbox and return another value (Employee Extension)from the same row. I am not sure of the best way to set this up. Lookup(IF, Marco....

Thank you for any support!!

Hi,

When you say "checkbox" do you mean the tick box from Form Control / Active X Control?

Perhaps if you could provide an example of your data...


All times are GMT +1. The time now is 10:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com