Questions about Vlookup

[amirshaneh]

i got a couple of questions about Vlookup Function.

1. whenever im using a vlookup funcion and im trying to drag the function down to more columns the table array is moving down aswell and i need that the table array will stay at the same place so it to take the data from the same positon.

2. is there an option that once it writes the value of the function it wont be changed again.
for example.

i already wrote alot of lines and its all good but i need to change the number in the table array but i what was in the history should stay the same... i dont want it to change what heppened in the history i just want it to change the number from now on.

i hope i made myself clear and thanks for the support.

[Domski]

1. You need to make your table array reference absolute like this: =VLOOKUP(A1,$F$1:$I$20,3,FALSE)

2. You would need to copy...paste special...values any formula you didn't want to update.

Dom

[TMS]

Q1: Make the look table address absolute.

For example, =VLOOKUP(A2,Sheet2!$A$2:$B$24,2,FALSE)


Q2: sorry, I don't understand the question. If you are saying you've added entries to the table and they're not included in the lookup, you could use a global replace of, say, ":24" to ":36" (without the quotes)


Regards

[amirshaneh]

thanks for the answer dom.

im speaking about alot of data and lines.... isnt there a way to do that without copy past special?

[Domski]

Not that I can think of.

Dom

[Pm129]

deleted- Started new thread

[Domski]

Hi,

You should start your own thread per the forum rules:

2. Don't post a question in the thread of another member -- start your own. If you feel it's particularly relevant, provide a link to the other thread.

Dom

[Pm129]

Apologies, The site wasn't letting me start threads. Will try again.