I have a spreadsheet I must compile information from multiple other workbooks to get the information I need. I have tried using the VLOOKUP function without success. =VLOOKUP(K2,DeptID,13,FALSE). I receive a #NA error. Can someone please help me figure this out?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Fields from Multiple workbooks into One Spreadsheet
- Thread starter sftyguy
- Start date
Excel Facts
Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
Automatrix
Active Member
- Joined
- Aug 15, 2022
- Messages
- 292
- Office Version
- 365
- Platform
- Windows
Power Query is built for that sort of stuff, you should look into using that. Hard to help more than that without more details.
Upvote
0
Similar threads
- Question
- Replies
- 5
- Views
- 279
- Question
- Replies
- 1
- Views
- 253
- Replies
- 0
- Views
- 236
