Excel 2007 : vlookup

[scambug]

Hi
I have problem, anyone can help give me a code for this.

i need to lookup all cell data in column A.[lookup value is in all colum a], table array is in worksheet 2[column A,B]output value must be the "value in colum B"

if a cell in colum A is blank then it will automatically gives a value "TBD"

appreciate your help.

Thank you.

[TMS]

=IF(A2="","TBD",IFERROR(VLOOKUP(A2, somewhere, a column, FALSE),"Not Found"))


Regards, TMS

[scambug]

Hi Sir,

hope this help.for clarifications.

[sushil10s]

See attachment

[scambug]

Hi sushil10s

this is a great help, but how can i code this to macro.
i need all data column A(infinity/A:A) [sheet-lookup] to be look up in column A&B(infinity/A:B) in [sheet-table array].

thanks.

[scambug]

i have code here that lookup Sheet1 col.A[no specific range], the lookup matrix is in sheet2 col A:B [with specific range].

heres the code

Please Login or Register  to view this content.

but my problem is how can i run this automatically and stop to where colA sheet1 has no value already.?

*//blankcell must also equal to "blank"
kindly see attachment.


Thanks