Refresh a cell that contains a formula

A

Aaron

I was given a spreadsheet with 2 worksheets. One worksheet contains the data
and the other is an interface called Quick Search. On the Quick Search sheet
there is a combo box pulling informormation from a column in the second
sheet. When the selection in the combo box changes it updates a
corresponding number in a hidden cell Q2. In another cell R11 a VLOOPKUP
formula exists to pull information and place it in another cell to view the
data.

What I need is when this combo box changes or the cell Q2 is updated with
the corresponding number, the VLOOKUP formula does not refresh it's data in
it's display fields. How can I best accomplish this?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Found few bugs in my daily routine of work in excel for MAC 0
Found few bugs in my daily routine of work in excel for MAC 0
Cell data entering slow! 0
Creating a Search using a combo box and then creating a report. 4
Dealing with the error: unable to filter on excel hc home school 0
Dynamic Naming of Form Button 3
Autonumber field in Excel that behaves the same as Access 0
Create if partial match then copy and paste data from one cell to another 1

Top