0

vlookup in Excel =VLOOKUP(A3,[Q_Joining_Demograph_Network_08.14.24.xlsx]Sheet2!$A:$A,2) is throwing a #REF! error in the cell.

tried using data>text to columns thinking the to columns are not the same data type. This is not working.

Improve this question
5
  • Are you trying to do vlookup across two excel workbooks? Commented Aug 15, 2024 at 12:29
  • 1
    yes two excel workbooks Commented Aug 15, 2024 at 12:36
  • Is the second workbook open, and have you double checked that you got its name right in your reference? Commented Aug 15, 2024 at 12:39
  • Actually this part looks weird as an Excel referenced $A:$A,2. I’m not an Excel expert so I may be wrong but I’d make sure it’s a valid reference on its own first within that workbook before trying the cross workbook vlookup. Commented Aug 15, 2024 at 12:41
  • I figured it out. You were correct I need to reference all the columns. $A:$F,2 Thank you. Commented Aug 15, 2024 at 14:11
Related questions
1
Subset Excel rows based on column values using vlookup
4
Excel VLOOKUP between two sheets failing
2
Excel VBA - Vlookup
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.