Home |
Search |
Today's Posts |
#1
|
|||
|
|||
vlookup.
Hello.
I am using vlookup to lookup a value from coloumn A and display the corresponding coloumn in the same row coloum C. I want to have vlookup look for value in coloumn A and also in coloumn A of another worksheet in the same workbook. Is this possible using vlookup? what else can i use? Thanks. |
#2
|
|||
|
|||
Amit,
Let's assume your range is A1:C10 on both worksheets (sheet 1 & 2), and you are looking up the value in E1. On sheet1: =VLOOKUP(E1,$A$1:$C$10,3,FALSE) will find the value in column C where the value in column A matches cell E1 precisely. =VLOOKUP(E1,Sheet2!$A$1:$C$10,3,FALSE) will look the value from cell E1 (on sheet1) up on sheet2 and return the value from column C on sheet2 which matches exactly. HTH Pete "Amit" wrote: Hello. I am using vlookup to lookup a value from coloumn A and display the corresponding coloumn in the same row coloum C. I want to have vlookup look for value in coloumn A and also in coloumn A of another worksheet in the same workbook. Is this possible using vlookup? what else can i use? Thanks. |
#3
|
|||
|
|||
If the value you are looking for is on Sheet1 in cell E1, and your second
table is on sheet2, the following will work: =VLOOKUP(E1,Sheet2!A:C,3,FALSE) "Amit" wrote: Hello. I am using vlookup to lookup a value from coloumn A and display the corresponding coloumn in the same row coloum C. I want to have vlookup look for value in coloumn A and also in coloumn A of another worksheet in the same workbook. Is this possible using vlookup? what else can i use? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup finds a blank, but returns a zero - HELP! | Excel Discussion (Misc queries) | |||
Vlookup Syntax Error | New Users to Excel | |||
Need help with modifying VLookUp | Excel Discussion (Misc queries) | |||
vlookup | Excel Worksheet Functions | |||
vlookup and IF function | Excel Worksheet Functions |