Re-Wring a formula in a Table

[daleholden]

[FONT=&quot]HI Guys[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]I currently have the following formula that checks a SKU then goes off to check Live Data sheet if nothing is found it goes to another sheet Own Stock and it works well.[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]Current formula =IFERROR(INDEX('Live Data'!A:N,MATCH(A1067,'Live Data'!A:A,0),MATCH(B1067,'Live Data'!$A$1:$N$1,0)),INDEX('Own Stock'!A:V,MATCH(A1067,'Own Stock'!A:A,0),MATCH(B1067,'Own Stock'!$A$1:$V$1,0)))*Sales!$G1067[/FONT]
[FONT=&quot]But i need it not just to check a SKU but also a entry from a drop-down list but i do not need it to check Own Stock Sheet.[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]So it needs re writing to check a SKU in column A then in column B is the drop-down from what i select it need to check check sku on Live data then check title from the headers to match from drop-down and select correct price.[/FONT]
[FONT=&quot]Drop-DOwn List[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]Live Data sheet headers[/FONT]

 

[daleholden]

HI Guys

I have solved it myself