Forum Discussion
Don't Know What Function(s) to Use! VLOOKUP Maybe?
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
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)
- 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.
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.
