Forum Discussion
vlook up Power query
Nathan, yes, that will be column with tables. Click on the icon with arrows on top right of that column header and extract Price and other fields which necessary. If you build relationship correctly it return Price or null if no related price. You may keep null as it is or replace it on zero.
SergeiBaklan Thanks for your reply. I tried to merge the two worksheets but the merger is just creating a column of "Tables".
You were right about the format though, the condition returns either 0, or the price.
Nathan.
Nathan, yes, that will be column with tables. Click on the icon with arrows on top right of that column header and extract Price and other fields which necessary. If you build relationship correctly it return Price or null if no related price. You may keep null as it is or replace it on zero.
SergeiBaklan Okay, that's working perfectly, thank you very much !
Nathan.
Nathan0763 , you are welcome