how to write if function to assign values to multiple cells not only one

Thaxx all for helping >>>Yes... every thing is good and vlookup is working



RoyUK ...yes I try your example and understand it ...I appreciate this


But I have new questions about : isna and macros


1- what is the work of (isna) and how to use it .

2- how can i assign a value of a2 -as example - to b4 -as example -

generally I want to put a [copy baste] operation in a larger macro

--the value is diffrent in each sheet i want to apply the macro on -
so i want the macro to take it as variable or cell value not as a static number




I donno how to say more than thaxx .... how to say this ??