Problem 1:
I have a main table tblply. And two sub-tables named tblcm5plypl n tblinch7plypr.
When i use formula
=VLOOKUP(F7,"tbl" & SUBSTITUTE(F6," ",""),2)
in G7, it gives me #value! error.
Pls help me correct this formula for various selections.
Problem 2:
The formula =CELL("contents",B2) gives CM5PLYPL under normal circumstances. But when same used in table header, gives 0. Why?
Sample file attached.
Do you really need all those messy tables?
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
If not (and I strongly suggest you dump them all), try this:
=VLOOKUP(F7,INDIRECT("tbl" & SUBSTITUTE(F6," ","")),2,0)
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
U didn't got my point. All these tables refer to various ply n their respective rates except for the first table.
I think that nflsales has given you what you need, though...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks