[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 284
  • Last Modified:

Return Value in Adjacent Cell w/ Trigger

Hello Experts,

Please bare with me as I explain this one...

On the Preview worksheet, cell F24 - this field needs to show values on the List worksheet, column F.

This information will change on the fly, so I need some type of trigger that will show the correct information.

For example...

Cell F24, on the Preview worksheet - needs to look at column G on the List worksheet, find the cell with a value of "1", then return the value in the cell to the LEFT.

Any ideas?

Thank you in advance for your help!

~ Geekamo
Pallet-Tag-Generator--Must-Enabl.xlsm
0
Geekamo
Asked:
Geekamo
1 Solution
 
Rgonzo1971Commented:
Hi,

Pls try
=INDEX(List!F2:F309,MATCH(1,List!G2:G309,0))

Open in new window

Regards
0
 
GeekamoAuthor Commented:
@ Rgonzo1971,

This is great!  Thank you so much!

~ Geekamo
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now