Hi all
I've attached an example of a sheet I need some help with please.
If A3 (product name) and C3 (date) match the cells in columns G-L, then I want cell B3 to copy the data.
I've given an example in B2.
Any help would be appreciated.
Hi all
I've attached an example of a sheet I need some help with please.
If A3 (product name) and C3 (date) match the cells in columns G-L, then I want cell B3 to copy the data.
I've given an example in B2.
Any help would be appreciated.
=index($h$2:$l$3,match($a2,$g$2:$g$3,0),match($c2,$h$1:$l$1))
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
=index($g$1:$l$3,match(a2,$g$1:$g$3,0),match(c2,$h$1:$l$1,0)+1)
Thanks but I don't think either of these work? Whenever I put in the formula, it gives the wrong price. For example, if I use the formula in B3, it gives a price of 1.533 but it should actually give 1.632 (cell K3).
These both formulas are ok you have to paste this in B2 and then fill down
Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks