Apr 11 2022 06:06 PM
Hi All,
It's been a while since I have used VLookup. I cannot get the formula to work in this instance and it's driving me crazy! I'm getting a #REF error and I can't figure out why.
Does this look correct to you?
=VLOOKUP(F2,Sheet1!C:C,2,FALSE)
I am looking to match emails in 2 sheets in the same workbook, and then return the value n the 2nd column on the 2nd sheet.
Apr 11 2022 06:08 PM
Apr 12 2022 08:12 AM
@mtarler Thank you! I keep getting N/A errors.. do numbers in a column for a VLookup need to be formatted in a specific way? I changed the formula to =VLOOKUP(F2,Sheet1!A:C,1,FALSE) and have tried the entire table array of A:E and I still can't get the formula to work. I am trying to bring over the values in column B.. the CaseSafe ID.
Apr 12 2022 12:14 PM