Hi !
I need to create a formula and I'm not sure which function would be best for that.
Basically I have different tables with the same products, with prices and other data (they are different suppliers).
Now I would like to have a formula that will check for the lowest price (a column) for a specific product (a column as well, all the different tables have the same values in this column) in all the different tables and return a value (maybe the name of the table, but the lowest price itself might be quite easier).
Which function would be best for this ?
Thanks !
Bookmarks