Vlookup & Dget (Excel97)

Topic

New Reply

I think that you need to post your Vlookup formula and Dget formula for anyone to be able to help you.
Also I assume you have tested that the Vlookup is giving you the results that you expect?

Peter

Reply | Quote

Replies

I am trying to use vlookup to gather the info needed for part of my Dget formula however; when I insert the value returned into my Dget formula the formula does not recognize the value (I end up with either #NA or #VALUE). If I type the value into the Dget formula it is just fine so the formula is written correctly. Is there a way to make this work or alternatively is there a way to write a macro that will piece together a range name (from data in two different cells) so that I can select and copy the approriate table to a fixed range. THANKS
formula in Cell A27 (to return name of table range)
=D8&G3
Formula in Cell B27 (to return square footage value which may not be exactly a number listed in the table)
=vlookup(C27,A27,1)
Formula in Cell B28) (to return value based on square footage and other elements)
=dget(A27,”Stone on Block”,B26:B27)

each formula works if the table range name is typed rather than using the A27 cell reference – A27 displays the correct range name

Reply | Quote

I think that you need to use the “Indirect” Function in your Vlookup

=vlookup(C27,indirect(A27),1)

I have not used Dget but it is probably the same problem

HTH

Peter

Reply | Quote

THANKS that works like a charm!

Reply | Quote