Excel Lookup Functions

T

TKS_Mark

Is there any way to use a lookup function other than indirect for the
following explanation?

I have a table with pipe sizes on the top row. On the first left column, I
have pipe schedules/material. If someone types in 2" for the pipe size and
schedule 40 SS for the sched/mat, I want to lookup the intersection of those
two date in the table. When I use vlookup or hlookup, they seem to want row
numbers or column numbers instead of header info.

Indirect is too much work defining separate names for columns and rows and
many people make mistakes. Indirect is difficult to troubleshoot. You can't
trace formulas that use indirect.

Thanks!
 
G

Gordon

TKS_Mark said:
Does anyone have any idea about this post? Please help.
Click to expand...


How do you mean "When I use vlookup or hlookup, they seem to want row
numbers or column numbers instead of header info" - you can tel V/HLookup
to use any set of data that you define....
 
Top