danhendo888
Board Regular
- Joined
- Jul 15, 2019
- Messages
- 147
- Office Version
- 365
- Platform
- Windows
https://1drv.ms/x/s!AvjBsEPEq12ngTMpaLVtqgZcYXLI?e=Hm2JrH
I am trying to do a Match lookup.
The value I am looking up could be in text or number format.
The search value can also be in text or number format.
What formula could I use that would work for all different combinations of formats, that is:
Number looking up number
number looking up text
text looking up number
text looking up text
E.g. in the link, I am looking up an invoice number. It is clearly there but the MATCH formula gets an N/A error.
I am trying to do a Match lookup.
The value I am looking up could be in text or number format.
The search value can also be in text or number format.
What formula could I use that would work for all different combinations of formats, that is:
Number looking up number
number looking up text
text looking up number
text looking up text
E.g. in the link, I am looking up an invoice number. It is clearly there but the MATCH formula gets an N/A error.