In M2 Cell of sales Shet
=L2&K2
Drag it down...
In D14 Cell of Quote Sheet
=IFERROR(INDEX(sales!E:E,MATCH(B8&B14,sales!M:M,0)),"-")
Drag it down...
Refer the attached file![]()
In M2 Cell of sales Shet
=L2&K2
Drag it down...
In D14 Cell of Quote Sheet
=IFERROR(INDEX(sales!E:E,MATCH(B8&B14,sales!M:M,0)),"-")
Drag it down...
Refer the attached file![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks