This is looking for a match in column A of the Appendix sheet and will
return the corresponding value from column B of that sheet if a match
is found - this is not what you described in your first posting.

Pete

On Sep 25, 2:04 am, nakliwala wrote:

Hi Pete,
Thanks for your response,....

i used the following vlookup:

=IF(ISNA(VLOOKUP(D2,'Appendix 7'!$A$2:$B$103,2,FALSE))," ",
VLOOKUP(D2,'Appendix 7'!$A$2:$B$103,2,FALSE))

In the existing sheet the vlookup was in column F. And the value in
the "Appendix" tab column A was what needed to be matched. the
vlookup i used seemed to work fine...if u see any problems with it
please let me know.

Thanks for your help!

~Nakli- Hide quoted text -

- Show quoted text -