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
This should do it. Helper columns not needed:
=VLOOKUP([@NAME]&[@PRODUCT],CHOOSE({1,2},Tablo2[NAME]&Tablo2[PRODUCT],Tablo2[REGION]),2,0)
- This is probably a better way without the helper column but I have spent like half an hour to make the other solution work and I don't want to start over. I may use this in the future though so thank you very much.