Quote:
Originally Posted by jeffreybrown
Well let's say your Vlookup is =VLOOKUP(A1,$D$1:$E$8,2,0)
If you add a record to row 9, the VLOOKUP would fail because it is not a dynamic range.
So instead, reference the entire column =VLOOKUP(A1,$D:$E,2,0)
|
Thx man, I followed your advice and I managed to get my formula work with new record inserted. Hopefully my lecturer satisfied with this approach.
Quote:
|
Originally Posted by Pecoflyer
It is indeed correct that you only need VLOOKUP ( although the INDEX/MATCH combination is much better IMO) using a dynamic range or a table as data source, so what's wrong with that?
You VLOOKUP would look something like =VLOOKUP("ab";Table1[#All];2;0) with a table
And I also think that using entire columns is not the best way to go as it forbids you to use those columns for other things than extending your data source
|
I tried many ways on making my vlookup formula dynamically and all of them work but my lecturer rejected them, saying that you only needed vlookup lol. I tried jeffreybrown's solution and it works but don't know whether my lect accept it or not. If not, then I'l use your solution and if he still rejected it then i dont know what else lol