Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 647
  • Last Modified:

Excel Formula

Hello Experts,

In the attached file, I need a formula under the "# of Boxes Used" column that will search the corresponding row of data and return the number that is in that row.

Thanks in advance. =)
EE---Sample-Lookup.xls
0
submarinerssbn731
Asked:
submarinerssbn731
1 Solution
 
NBVCCommented:
Hi,

Give this a try:

=LOOKUP(10^10,B3:K3)

copied down.
0
 
submarinerssbn731Author Commented:
Works perfectly. Thank you!
0
 
Rob HensonIT & Database AssistantCommented:
Will there be more than one number? If so which number or will a sum of the row be required?

=SUM(B3:K3) copied down to row 10

Thanks
Rob H
0

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now