khaledocom
06-08-2013, 04:48 AM
Good morning all,
In column A starting from A6 there are some values, I need in coumn B
Starting from B6 the following formula:
"=IF(A6<>"",$A$2&A6,"")"
Starting from C6 the formula:
"=IF(A6<>"",IF(ISNA(VLOOKUP(LEFT(A6,8),Data!A:H,2,0)),"Not Available",VLOOKUP(LEFT(A6,8),Data!A:H,2,0)),"")"
Starting from D6 the formula:
"=IF(A6<>"",IF(ISNA(VLOOKUP(LEFT(A6,8),Data!A:H,3,0)),"Not Available",VLOOKUP(LEFT(A6,8),Data!A:H,3,0)),"")"
and fill down to last used cell in column A
Please help, Thanks.
In column A starting from A6 there are some values, I need in coumn B
Starting from B6 the following formula:
"=IF(A6<>"",$A$2&A6,"")"
Starting from C6 the formula:
"=IF(A6<>"",IF(ISNA(VLOOKUP(LEFT(A6,8),Data!A:H,2,0)),"Not Available",VLOOKUP(LEFT(A6,8),Data!A:H,2,0)),"")"
Starting from D6 the formula:
"=IF(A6<>"",IF(ISNA(VLOOKUP(LEFT(A6,8),Data!A:H,3,0)),"Not Available",VLOOKUP(LEFT(A6,8),Data!A:H,3,0)),"")"
and fill down to last used cell in column A
Please help, Thanks.