Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Works if I copy F Col to A Col
Hello from Steved
The below formula works ok If I use the lookup reference in A column. I need this to use the below in F column in stead off A Please. =IF(ISNA(VLOOKUP(--A7,Sheet2!$A$2:$H$50000,2,FALSE))," ",VLOOKUP(--A7,Sheet2!$A$2:$H$50000,2,FALSE)). Thankyou. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Works if I copy F Col to A Col
Could you provide more information on your problem? Are you trying to copy the formula from column A to F or trying to lookup values in column F instead of A? -- C01d ------------------------------------------------------------------------ C01d's Profile: http://www.excelforum.com/member.php...o&userid=34422 View this thread: http://www.excelforum.com/showthread...hreadid=546582 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Works if I copy F Col to A Col
Hello From Steved
trying to lookup values in column F instead of A? What I done was to insert a column in A then copied the F Col to check to see if the formula would work and it does now i've put the information back in Column F. "C01d" wrote: Could you provide more information on your problem? Are you trying to copy the formula from column A to F or trying to lookup values in column F instead of A? -- C01d ------------------------------------------------------------------------ C01d's Profile: http://www.excelforum.com/member.php...o&userid=34422 View this thread: http://www.excelforum.com/showthread...hreadid=546582 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Works if I copy F Col to A Col
The lookup value must be in the first column of the range.
From help on vlookup: Syntax VLOOKUP(lookup_value,table_array,col_index_num,ran ge_lookup) Lookup_value is the value to be found in the first column of the array. Lookup_value can be a value, a reference, or a text string. -- Carlos "Steved" wrote in message ... Hello From Steved trying to lookup values in column F instead of A? What I done was to insert a column in A then copied the F Col to check to see if the formula would work and it does now i've put the information back in Column F. "C01d" wrote: Could you provide more information on your problem? Are you trying to copy the formula from column A to F or trying to lookup values in column F instead of A? -- C01d ------------------------------------------------------------------------ C01d's Profile: http://www.excelforum.com/member.php...o&userid=34422 View this thread: http://www.excelforum.com/showthread...hreadid=546582 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Works if I copy F Col to A Col
Thanks Carlos I thought this may be the case.
"Carlos Antenna" wrote: The lookup value must be in the first column of the range. From help on vlookup: Syntax VLOOKUP(lookup_value,table_array,col_index_num,ran ge_lookup) Lookup_value is the value to be found in the first column of the array. Lookup_value can be a value, a reference, or a text string. -- Carlos "Steved" wrote in message ... Hello From Steved trying to lookup values in column F instead of A? What I done was to insert a column in A then copied the F Col to check to see if the formula would work and it does now i've put the information back in Column F. "C01d" wrote: Could you provide more information on your problem? Are you trying to copy the formula from column A to F or trying to lookup values in column F instead of A? -- C01d ------------------------------------------------------------------------ C01d's Profile: http://www.excelforum.com/member.php...o&userid=34422 View this thread: http://www.excelforum.com/showthread...hreadid=546582 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Works if I copy F Col to A Col
Then, just use the Index() & Match() combo:
=IF(ISNA(MATCH(--A7,Sheet2!$F$2:$F$50000,0)),"",INDEX(Sheet2!$A$2:$ H$50000,M ATCH(--A7,Sheet2!$F$2:$F$50000,0),2)) -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Steved" wrote in message ... Thanks Carlos I thought this may be the case. "Carlos Antenna" wrote: The lookup value must be in the first column of the range. From help on vlookup: Syntax VLOOKUP(lookup_value,table_array,col_index_num,ran ge_lookup) Lookup_value is the value to be found in the first column of the array. Lookup_value can be a value, a reference, or a text string. -- Carlos "Steved" wrote in message ... Hello From Steved trying to lookup values in column F instead of A? What I done was to insert a column in A then copied the F Col to check to see if the formula would work and it does now i've put the information back in Column F. "C01d" wrote: Could you provide more information on your problem? Are you trying to copy the formula from column A to F or trying to lookup values in column F instead of A? -- C01d ------------------------------------------------------------------------ C01d's Profile: http://www.excelforum.com/member.php...o&userid=34422 View this thread: http://www.excelforum.com/showthread...hreadid=546582 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Works if I copy F Col to A Col
Excellent and Thankyou.
"RagDyeR" wrote: Then, just use the Index() & Match() combo: =IF(ISNA(MATCH(--A7,Sheet2!$F$2:$F$50000,0)),"",INDEX(Sheet2!$A$2:$ H$50000,M ATCH(--A7,Sheet2!$F$2:$F$50000,0),2)) -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Steved" wrote in message ... Thanks Carlos I thought this may be the case. "Carlos Antenna" wrote: The lookup value must be in the first column of the range. From help on vlookup: Syntax VLOOKUP(lookup_value,table_array,col_index_num,ran ge_lookup) Lookup_value is the value to be found in the first column of the array. Lookup_value can be a value, a reference, or a text string. -- Carlos "Steved" wrote in message ... Hello From Steved trying to lookup values in column F instead of A? What I done was to insert a column in A then copied the F Col to check to see if the formula would work and it does now i've put the information back in Column F. "C01d" wrote: Could you provide more information on your problem? Are you trying to copy the formula from column A to F or trying to lookup values in column F instead of A? -- C01d ------------------------------------------------------------------------ C01d's Profile: http://www.excelforum.com/member.php...o&userid=34422 View this thread: http://www.excelforum.com/showthread...hreadid=546582 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disable Cut & Copy then restore on exiting | Excel Discussion (Misc queries) | |||
copy between worksheets does not copy formulae just values | Excel Discussion (Misc queries) | |||
Copy without Hidden Cols - How | Excel Discussion (Misc queries) | |||
How do I convert works file to excel without works software? | Excel Discussion (Misc queries) | |||
I cannot paste from one workbook to another. Copy works, paste do. | Excel Discussion (Misc queries) |