Microsoft Office Forums - View Single Post - [Solved] Is this possible using the Vlookup or any other function?

Thread: [Solved] Is this possible using the Vlookup or any other function?

View Single Post

Old

02-08-2010, 01:27 PM

ConneXionLost ConneXionLost is offline

ConneXionLost is offline

ConneXionLost uses Windows XP

Windows XP ConneXionLost uses Office 2003

ConneXionLost uses Office 2003

Office 2003

Simulacrum

Join Date: Jan 2010

Location: Victoria, Canada

Posts: 86

ConneXionLost is on a distinguished road

Default

Hi Delson,

Try this:

Code:

=IF(ISNA(MATCH(A21,Sheet2!$I$2:Sheet2!$I$6498,0)),"Not in List",VLOOKUP(A21,Sheet2!$I$2:Sheet2!$L$6498,4,0))

Cheers,

Reply With Quote