Creating a Macro with a lookup command

[mcedmond]

Hi all! Im new to the world of creating macros in excel and definitely am in need of some helpful information.

What I need to do is create a macro that will populate certain cells with cost information that is located on a main spreadsheet. I know I need to use a lookup command, but I'm not sure if i have to select the cells individually or the entire column since only some of the cells need to be filled out- possible if command? (and this number changes each time). I have many templates that all have the similar formats but different products. There is already on macro that is being ran but it generates data for only the products that are made by our company. I would like to create a macro that will populate the cells related to our 3rd party products without interfering with the results of the previous macro.

Any help would be much appreciated!

[venkat1926]

you can use conditional vlookup
example
you can have this formula in C1
=if(B1<>"".vlookup(...........),"')

that is if b1 is not blank the vlookup is done on C1 . if B1 blank c1 is blank.