LinkBack URL
About LinkBacks
Hi,
before you copy your formula down you'll have to apply absolute references, otherwise they'll be adjusted as the formula is copied down the rows.
=HLOOKUP(A1,$K$1:$M$2,2,0)
will not change the K1:M2 reference.
hth
Hi,
before you copy your formula down you'll have to apply absolute references, otherwise they'll be adjusted as the formula is copied down the rows.
=HLOOKUP(A1,$K$1:$M$2,2,0)
will not change the K1:M2 reference.
hth
Did that and worked perfectly.
When I copy down I still get #N/A for cells that have not yet been picked by the pull down. Possible to enter a phrases like "Not Used" or just have it default as a value of zero if the pull down is not used?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks