Trying to figure out a Formula, need help.

T

TMich

New Member
Joined
Feb 24, 2022
Messages
1
Office Version
  1. 2019
Platform
  1. Windows
I only just started learning Excel and I need help with a formula. This is a project that I am working on right now:
1645716031687.png


Column A and B stretch out in the thousands. Instead of someone using Ctrl+F to find a document, I would like for them to insert the value in the Search: Doc # (cell D8) and the document name would pop up in the next cell (E8), or vice versa. Could someone help me with this. Thanks.
 

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number
Sort by date Sort by votes
Welcome to the Board!

You can do this quite easily using a VLOOKUP formula.
See here for details on how to create that: VLOOKUP function in Excel
 
Upvote 0
You must log in or register to reply here.

Similar threads

P
  • Question
Can you co-author an excel file without using SharePoint or OneDrive? Possible other options available?
Replies
0
Views
1K
PA_VA13
P
B
  • Question
Formula Help
Replies
6
Views
115
Fluff
Fluff
J
  • Question
Need to work out occupancy rate and to filter
Replies
2
Views
116
awoohaw
awoohaw
J
  • Question
VBA Macros running slow out of nowhere
Replies
3
Views
193
mumps
mumps
N
  • Question
VBA - Go to cell based on cell address in another cell
Replies
2
Views
158
nx4737
N

Forum statistics

Threads
1,214,587
Messages
6,120,406
Members
448,958
Latest member
Hat4Life

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top