As per attached excel file.
kindly refer sheet "quotation history". This sheet is the history of quotation as per Quote No.
the other sheet "QUOTE" is using to send the quotation to customer. how can i take data from "quotation history" by just entering the "Quote no.
a19=IFERROR(INDEX('quotation history'!A:A,SMALL(INDEX((Table558[Quote no]<>quote!$G$3)*10^10+ROW(Table558[Quote no]),0),ROW(1:1))),"")
b19=IFERROR(INDEX('quotation history'!b:b,SMALL(INDEX((Table558[Quote no]<>quote!$G$3)*10^10+ROW(Table558[Quote no]),0),ROW(1:1))),"")
d19=IFERROR(INDEX('quotation history'!c:c,SMALL(INDEX((Table558[Quote no]<>quote!$G$3)*10^10+ROW(Table558[Quote no]),0),ROW(1:1))),"")
e19=IFERROR(INDEX('quotation history'!d:d,SMALL(INDEX((Table558[Quote no]<>quote!$G$3)*10^10+ROW(Table558[Quote no]),0),ROW(1:1))),"")
f19=IFERROR(INDEX('quotation history'!e:e,SMALL(INDEX((Table558[Quote no]<>quote!$G$3)*10^10+ROW(Table558[Quote no]),0),ROW(1:1))),"")
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
sorry i am not able to use above formula. i think there are some problem
please can you apply directly in the sheet or recheck if this is ok
See the attached file
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks