•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Newish to excel and need guidance using formulas
I’m trying to find 423 lines of numbers within 800 and just need excel to tell me “yes, it’s here (ie: Yes,A8)” or N/A.
The 800 line items are paired with their respective data and I’m trying to avoid using Ctrl-F 423 times. Is there a formula to help me with this? I tried using a YouTube tutorial on =VLookup with no luck. I tried turning the columns into tables and filtering and that made it worse.
The formula I last used was =VLOOKUP(G1,$I1:$I800,9,False) with the formula placed in the empty H column in hopes it would tell me “yes and here’s where it is”or “No”.
Any help would be greatly appreciated. Thank you.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#financial modeling with spreadsheets
#Excel alternatives for data analysis
#AI formula generation techniques
#formula generator
#Excel compatibility
#Excel alternatives
#rows.com
#big data management in spreadsheets
#generative AI for data analysis
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#Excel
#formulas
#VLOOKUP