Hello All
please see attahed
Sheet 1
Data that’s pasted in daily, part number positions and all other data changes daily basis in terms or rows, columns are static
on tab BMW E89 (Z4)
I’d like column A to display the part numbers from sheet 1, based on the Description in D, But only IF there is a qty in H
I’ve manually typed the expected results in
Paul
You have manually typed in the results, but where did the results come from?
Your other sheet has no data.
its from sheet1 tab, scroll over to the left a bit
This is all you have.
Not sure what is supposed to happen.
-
sht1sht2.jpg
please see attached
Sheet1 is now there
Please rename header in BMW E89 (Z4) row 3 to macth column you want to display
A4 drag across and down
=IFERROR(INDEX(Sheet1!$A:$H,AGGREGATE(15,6,ROW(Sheet1!$D$2:$D$999)/(Sheet1!$D$2:$D$999=$A$1)/(Sheet1!$H$2:$H$999>0),ROWS(A$4:A4)),MATCH(A$3,Sheet1!$A$1:$H$1,)),"")
BO - that is great
thank you so much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks