Forum Discussion
Solved
Don't Know What Function(s) to Use! VLOOKUP Maybe?
Hi. Here is what I want to do; in page1 NAME column has a name, PRODUCT column has a product name and REGION column has a region name, in page2 when I write NAME and PRODUCT I want REGION in page1 to...
Hi
In order for VLOOKUP to work in this scenario you need to insert a 'dummy' column where you concatenate the NAME & PRODCUT - see example attached. You can always hide the 'dummy' column if you don't want the user to see it.
hope this helps.
Peter
peteryac60 I have tried to be more specific in the example file. PAGE1 will be locked, PAGE2 will take data from PAGE1
Hi
In order for VLOOKUP to work in this scenario you need to insert a 'dummy' column where you concatenate the NAME & PRODCUT - see example attached. You can always hide the 'dummy' column if you don't want the user to see it.
hope this helps.
Peter
- It works as I wanted, thank you.