Dear Excel Whizzes & Wizards
I am trying to match a code to one s/sheet from another within the same workbook. I pretty much copied a formula sequence from my predecessor's files to no avail.
Please take a look at my formula in Cell V3 of my dummy file and advise where I have gone wrong. Attached are .xlsx file and image of error message.
I have searched through other VLook Up threads on your site but as I am only just getting to grips with understanding it, I didn't find an answer to what I think I needed or if it was there, I didn't understand! Sorry, I am keen to become and Excel Ninja or Guru and hope you can be patient with me
Many thanks
Mayhem
I am trying to match a code to one s/sheet from another within the same workbook. I pretty much copied a formula sequence from my predecessor's files to no avail.
Please take a look at my formula in Cell V3 of my dummy file and advise where I have gone wrong. Attached are .xlsx file and image of error message.
I have searched through other VLook Up threads on your site but as I am only just getting to grips with understanding it, I didn't find an answer to what I think I needed or if it was there, I didn't understand! Sorry, I am keen to become and Excel Ninja or Guru and hope you can be patient with me
Many thanks
Mayhem