Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup
Hi,
I wanted to use IF and Vlookup formula to find data from Sheet1 into Sheet2 in the same spreadsheet. I wanted the formula to look at Cells A2:A20 in Sheet1 and in Sheet2 for match, if those information match, put the data find in cells C2:C20 in Sheet1 into C2:C20 of Sheet2 -Something like IF('Sheet1'!A2:A20=A2:A20, Vlookup('Sheet1'!C2:C20)) -I'm using the following formula in sheet2 but it returning #VALUE! =IF(C2="","",(VLOOKUP(Sheet1!$A$2:$D$11,3,FALSE))) Can anyone assist me? Thanks -- Emmanuel K. Agbovi Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200806/1 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup
You need something to lookup. Perhaps you want to look up c2
=IF(C2="","",VLOOKUP(c2,Sheet1!$A$2:$D$11,3,FALSE) ) -- Don Guillett Microsoft MVP Excel SalesAid Software "Eman via OfficeKB.com" <u43129@uwe wrote in message news:8605496dd8e5f@uwe... Hi, I wanted to use IF and Vlookup formula to find data from Sheet1 into Sheet2 in the same spreadsheet. I wanted the formula to look at Cells A2:A20 in Sheet1 and in Sheet2 for match, if those information match, put the data find in cells C2:C20 in Sheet1 into C2:C20 of Sheet2 -Something like IF('Sheet1'!A2:A20=A2:A20, Vlookup('Sheet1'!C2:C20)) -I'm using the following formula in sheet2 but it returning #VALUE! =IF(C2="","",(VLOOKUP(Sheet1!$A$2:$D$11,3,FALSE))) Can anyone assist me? Thanks -- Emmanuel K. Agbovi Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200806/1 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup
Enter this formula on sheet2 C2:
=VLOOKUP(A2,Sheet1!A$2:C$20,3,0) Copy down as needed -- Biff Microsoft Excel MVP "Eman via OfficeKB.com" <u43129@uwe wrote in message news:8605496dd8e5f@uwe... Hi, I wanted to use IF and Vlookup formula to find data from Sheet1 into Sheet2 in the same spreadsheet. I wanted the formula to look at Cells A2:A20 in Sheet1 and in Sheet2 for match, if those information match, put the data find in cells C2:C20 in Sheet1 into C2:C20 of Sheet2 -Something like IF('Sheet1'!A2:A20=A2:A20, Vlookup('Sheet1'!C2:C20)) -I'm using the following formula in sheet2 but it returning #VALUE! =IF(C2="","",(VLOOKUP(Sheet1!$A$2:$D$11,3,FALSE))) Can anyone assist me? Thanks -- Emmanuel K. Agbovi Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200806/1 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup
Thanks T. Valko, It works
Best T. Valko wrote: Enter this formula on sheet2 C2: =VLOOKUP(A2,Sheet1!A$2:C$20,3,0) Copy down as needed Hi, I wanted to use IF and Vlookup formula to find data from Sheet1 into [quoted text clipped - 9 lines] Can anyone assist me? Thanks -- Emmanuel K. Agbovi Message posted via http://www.officekb.com |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Eman via OfficeKB.com" <u43129@uwe wrote in message news:86272519ca2ce@uwe... Thanks T. Valko, It works Best T. Valko wrote: Enter this formula on sheet2 C2: =VLOOKUP(A2,Sheet1!A$2:C$20,3,0) Copy down as needed Hi, I wanted to use IF and Vlookup formula to find data from Sheet1 into [quoted text clipped - 9 lines] Can anyone assist me? Thanks -- Emmanuel K. Agbovi Message posted via http://www.officekb.com |
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 |