Matthias1992
New Member
- Joined
- Mar 3, 2016
- Messages
- 14
Hi guys
I am using this formula =INDEX($A$1:$N$211, MATCH(Q4,A1:A211,0),MATCH(R4,A1:N1,0)).
Now how can i remake it that is looks for the info in the worksheet "prices". The formula is typed in the worksheet "invoices".
Thanks alot!
I am using this formula =INDEX($A$1:$N$211, MATCH(Q4,A1:A211,0),MATCH(R4,A1:N1,0)).
Now how can i remake it that is looks for the info in the worksheet "prices". The formula is typed in the worksheet "invoices".
Thanks alot!