Hi, firstly I'm not sure if the title explains very well my issue so I'll explain what the function needs to do.
I have two sheets with numerous columns on, some similar, some not. On my first sheet I need to look up the value in A1 for the similar value in the second sheet but I need to look...