Subject

ZIP

Search

Microsoft Excel Excel

Asked • 03/16/19

Is there a formula in Excel that returns the cell value of a table, by finding the column and row that meets certain criteria?

More

2 Answers By Expert Tutors

By:

Nikolay M. answered • 03/26/19

Tutor

5.0 (548)

PhD in STEM with 25+ Years of Coding Experience

See tutors like this

Usually this done by a combination of HLOOKUP or VLOOKUP.

But depending on what the criteria is one may need a custom VBA worksheet function.

Upvote 0 Downvote

More

Patrick B. answered • 03/16/19

Tutor

4.7 (31)

Math and computer tutor/teacher

See tutors like this

Lookup

vLookup,

hLookup,

Upvote 0 Downvote

More

Still looking for help? Get the right answer, fast.

Ask a question for free

Get a free answer to a quick problem.
Most questions answered within 4 hours.

Find an Online Tutor Now

Choose an expert and meet online. No packages or subscriptions, pay only for the time you need.