Forum Discussion
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 fill the cell in page2 automatically.
There is a simplified example below.
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
8 Replies
- 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.
Hi
You can use VLOOKUP however....
You need to provide more data so we can determine what field should be used in the VLOOKUP. For example, you can do a lookup on the PRODUCT column. But this will only work if there is only 1 row for each product. Or you can do a lookup on NAME but again this will only work if each NAME is unique.
Please provide more data so we can determine how best to proceed.
thanks
Peter
peteryac60 I have tried to be more specific in the example file. PAGE1 will be locked, PAGE2 will take data from PAGE1
This should do it. Helper columns not needed:
=VLOOKUP([@NAME]&[@PRODUCT],CHOOSE({1,2},Tablo2[NAME]&Tablo2[PRODUCT],Tablo2[REGION]),2,0)
