Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
VLOOKUP
Hi,
I was trying to use VLOOKUP, to check whether the data for employees in the 1st worksheet exists in the 2nd sheet as well. I realise that when I drag the formula to ensure that the same formula can be used for all the rows below, the formula tends to change the table array destination also along with the lookup value. The formula for the first row looks like this - =vlookup(A34, Sheet2!A2:B518,2,false) When I drag this formula it changes to - =vlookup(A35, Sheet2!A3:B519,2,false) I want the lookup value to change from A34 to A35, but I do not wish the table array to change from Sheet2!A2:B518 to Sheet2!A3:B519. Would you be able to let me know what needs to be done here? Where am I going wrong? Thanks in advance & Regards Vidya |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
IF(AND(val1=VLOOKUP( );val2>=VLOOKUP( );val2<=VLOOKUP( );VLOOKUP( | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |