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
INDEX returns a specific value. This is the primary function of VLOOKUP, given a set of parameters; you can quickly find a needed value. Now the only thing we are missing is a way to find the row position. If you have to find this manually you lose the utility of a function.