Looking up 1 cell in two ranges in different worksheets
2019.12.22 21:24 perambulator747 Looking up 1 cell in two ranges in different worksheets
I am trying to find the best function to do the following:
A1 in Sheet 1 has a date. Excel must find the date, in A1, in a range in Sheet 2 and in a range in Sheet 3. If Excel finds that date (in Sheet 2 or Sheet 3), it must return a particular text string. If it doesn't find it, it must return another text string. The date will either be in Sheet 2 or Sheet 3 - it won't be in both, but Excel must try to find it the date in both sheets.
I have access to XMATCH and XLOOKUP, but they're not working well when I am trying to select the "lookup_array" across multiple worksheets. In another application, using XLOOKUP, I am aware that I can select multiple "lookup_array" ranges in multiple worksheets using the concatenation ampersand symbol and that works well.
I think the SWITCH function could work, but trying to nest an XMATCH and XLOOKUP is getting a bit messy.
Any suggestions would be appreciated.
submitted by perambulator747
to excel [link] [comments]
2019.02.01 22:35 readycool766744 XMatch.com : Watch This XMatch.com Review Learn If XMatch.com Is A Scam Or Legit 😘
https://reddit.com/link/am72z8/video/3wgvcdpez0e21/player 😘😘 My recommended site: http://bit.ly/2BglzWB
XMatch.com : Watch This X Match Review Learn If XMatch Is A Scam Or Legit
Please watch this honest video review of XMatch and learn if this site is a rip off scam or a legit dating site to meet girls on. This video review shows you the truth so you won't get scammed when searching for a place to meet local women.
submitted by readycool766744
to u/readycool766744 [link] [comments]
2011.07.26 12:40 bookmarking95 Are You Looking For a Adult Social Network?
Are You Looking For a Adult Social Network? The Best ADULT Social Network For Both Men&Women Looking to HAVE Sexual Match ADULT Dating ADULT Chat Your Sexual Match Is Just a Click Away at www.fuckbookofsex.xmatch.com
submitted by bookmarking95
to reddit.com [link] [comments]