Hi
attaching a sample sheet might help
Hi all, I need to look up a value based on two search criteria:
1) the month and year must match but not the exact date
2) The reference number must match (The range being searched has other text too so search will based on 'contains text' sort of thing)
I can't quite figure out what formula I use and how do I implement it..any help would be much appreciated.
Hi
attaching a sample sheet might help
Edit your post click " Go advanced" and click on the paperclip icon, then follow the instructions to upload. ( uploading a sheet instead of an image makes things easier for everybody )![]()
Last edited by Pecoflyer; 2011-12-31 at 03:03 PM.
Or in a new post click reply>Go advanced and you'll see the attachment tools there as Pecoflyer explained.
Kind regards,
Simon Lloyd
Bookmarks