This, will also work
=INDEX(Products!$A$2:$B$5, MATCH(order!$A$2,Products!$A$2:$A$5,0),2)
In B2 on the order tab
This, will also work
=INDEX(Products!$A$2:$B$5, MATCH(order!$A$2,Products!$A$2:$A$5,0),2)
In B2 on the order tab
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks