Fringedweller
New Member
- Joined
- Jan 21, 2018
- Messages
- 6
Firstly, Hello all
I am trying to correct this formula as it returns a #Value error =INDEX(AG$5:AG$31,MATCH(B11,AG$5:AG$301,0),AH5)
looking to display the contents of AH5 (which is a Purchase Order number) in say cell Z1
Thank you in advance
I am trying to correct this formula as it returns a #Value error =INDEX(AG$5:AG$31,MATCH(B11,AG$5:AG$301,0),AH5)
looking to display the contents of AH5 (which is a Purchase Order number) in say cell Z1
- if I use the evaluate function it does show it is looking at the correct cell, as I can see the PO number.
Thank you in advance